I'm trying to run a macro that replaces data in a table in Excel, when the data might initially be filtered. The code should remove the filter first, then run
I have this kind of column in my Excel: A B gbgdf, dsfsd, gdgdf, TC-EVTgfdsfs, gdfgd, I am willing to copy every cell that is NOT starting with
I'm attempting to pull contact information from an Outlook.ExchangeUser object using VBA in Excel. However, so far I've only been able to get the primary SMTP a
I have written a code in R which is supposed to retrieve certain information from a website and import it into an Excel file. I have used it for one website and
I'm using PhpSpreadSheet and I need to save the sheets contained in a workbook as individual CSV files. I've tried to use $reader->setLoadAllSheets(); but
I try to take a table and create a pivot table adjacent to it. This macro needs to work on separate worksheets so the table and pivot table names need to be ge
I am getting unexpected results when passing a boolean() array to a variant type (the variant type resides inside a class module). I expect to get a value of tr
I have a DataTable with 200,000 rows. I want to export DataTable in excel file. But it gives System.OutOfMemoryException error. using (ExcelPackage objExcelPa
I am trying to create a formula that returns the concatenation of two arrays of different lengths. I need this concatenation for part of anoth
I'm trying to accomplish that if you click on a hyperlink (in column P), it would copy the cell in the same row but in column B to another cell (A3). I'vre trie
I am new to Excel VBA. With reference from a search engine I have created the above code but stuck at one point. My requirement is to sum data in the range of s
I'm using MS Excel O365 Business in version 1905 (compilation 11629.20196). In this case i have created two sheets: 1) "Orders" 2) Order_status NUMBER_ORD
I am trying to update an existing Excel file with many formulas. I can't use evaluate-function ( Excel-file contains a function not supported by Apache POI )
Is there a way to load/import an HDF5 file (sometimes called H5, HD5, or Hierarchical Data Format) in to Excel? I do not want to export an intermediary CSV fi
I am coding simple application having one window form using c# in visual studio, app exe will be opened by excel VBA macro and the application will read the val
I would like to write a user-defined function CHOOSERANGE that returns a range from 4 coordinates. The first version is as follows: CHOOSERANGE = LAMBDA(row_min
Is there a function in Excel that will automatically change the hyperlink (hyperlink from a cell on one sheet to cells on another sheet) destination? For exam
I need help in replacing missing values in the following dummy file. The following rule need to be followed when replacing a missing value. If the value is the
Microsoft Visual Basic for Applications 7.1; Version 1088 I created a custom error handler by following online tutorials and I've been us
I am trying to embed a range from a worksheet as an image in outlook mail body. It's saving the picture correctly but I only see blank image in the outlook mail