Category "excel"

Clear filter from Table

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

Excel copy cell from a column if value is starting with Formula

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

How to get Microsoft Exchange email addresses other than the primary SMTP address using VBA

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

Using R code to scrape data from a webpage into an Excel file

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

PhpSpreadSheet: How to save Workbook sheets in individual CSV files

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

create a repeatable pivot table that loads on the same worksheet

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

boolean array and variant type vba

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

Export to excel in c# results in System.OutOfMemoryException

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

Is there a way to concatenate two arrays in Excel without VBA? [duplicate]

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

Target.Range.Offset - or something like that

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

How to sum and Copy paste in sheet 2 row incrementally

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

Vlookup - how to deal with #n/a errors - office 365

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

Apache POI : delete the cached results from the file

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 )

Load HDF5 in Excel?

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

SheetChange event is not getting changes of active excel cell when performing another function

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

INDIRECT and OFFSET in the function body make a name special

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

How to automatically change hyperlink destination in Excel

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

replacing missing values in r

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

Why do we need to use vbObjectError constant when raising user-defined errors in VBA? [duplicate]

Microsoft Visual Basic for Applications 7.1; Version 1088 I created a custom error handler by following online tutorials and I've been us

Embed picture in outlook mail body excel vba

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