Category "excel"

Remove Excel workbook onSelectionChange event

I am working on a Excel Web Add-In using Office.js. I added onSelectionChange event for a workbook and later trying to remove it, but this event still works. He

Hide #NA displayed in the cell by formula =IFERROR(~~~,NA())

I'm trying to format my excel sheet and to display organized chart, I have to do( A1~A100 ) IFERROR($B1+$C1,NA()) To make cells #NA value instead of IFERROR($B

How do I reply to outlook mail using vba in excel with mail thread?

I am looking for VBA code in excel to reply to a selected mail but the below code creates seperate mail which does not have previous messages in conversation (t

Javascript/Excel non-linear X axis/different scale

Is there any way to replicate the graph on the left in Excel? If not, any way to do it in JavaScript/Python? The upper scale on the X axis is different than low

How do you skip prefilled cells and also fill in the blank cells with no duplicates?

I am trying to skip cells that have prefilled data. If I were to select a day of the week in my schedule certain people would have the day off. I am trying to s

Error 400 when deleting strikethrough text

I have Excel VBA code to delete strikethrough text: Private Sub DelStrikethroughText() 'Deletes strikethrough text in all selected cells Dim Cell

Split string cell into multi rows but keep original row

I have a macro that splits a string (list of names) using a space as the delimiter and creates a new row for each name while keeping all data the same in other

How to develop ms excel ribbon functions

how to develop ms excel ribbon functionality not COM add-ins or VSTO add-ins. Using visual studio Thank you I want to implement excel ribbon functions to valida

PDDoc.Save Adobe Acrobat method not working in Excel VBA

Our office runs Arobat DC Pro and Excel 2016, we have been using the code below (scaled down version) in Excel VBA for years to save active Adobe PDF documents

Is there a way to identify if a worksheet has a highlighted cell at a worksheet level, without checking all the cells?

Is there a way to identify if a worksheet has a highlighted cell at a worksheet level, without checking all the cells? Further context: I have a WorkBook with a

Make array of numbers in one cell in Excel [closed]

Is it possible to store some numbers in one cell (as an array)? Please see below: cell A1: 4,4,3,4,1,3,3,4 cell A2: 5 (5th element of array)

Save picture as a picture instead of link when using VBA in Excel

I have an Excel file for label template with 6,300 items (each item has a parent ID which matches the picture name that suits the child item). I found code that

Excel group pivot table columns by more criteria

I have pivot table amount columns: 0-100, 100-200, 200-300, 300-400, 400-500 How to make group by more criteria? I want until 100 group by 25, then from 100 u

Skipping certain amount of cells if a condition is true in a for loop (Python)

I'm trying to tell python to insert "No work" in certain amount of cells, depending on how many days has passed since the codes was run. So basically, let imagi

How to copy a column value if condition is met in cell to the left

I currently have code that inserts two columns, and copies values from two other columns into these two new columns. 'Insert 2 Column to the Left of S Colum

VBA doesn´t add datalabel

I have an existent graph to which I added a macros. The macros should update the axes, add a datalabel to the last point and delete the datalabel of the previou

INDIRECT and CELL to dynamically get value from other worksheet, not working

Trying to dynamically get cell value from worksheet in same workbook, depending on worksheet name in column E =IF(E108<>"",INDIRECT(CELL("contents", E108)

Can I read other than the first sheet with the Read Delimited Spreadsheet.vi function in LabVIEW?

I am using Read Delimited Spreadsheet.vi in LabVIEW and need to read data from other than the first sheet. How do I tell LabVIEW that want to use other than the

Unable to import from Sharepoint Excel file to an R dataset

I am trying to download an Excel in Sharepoint site into an R dataset. But I keep getting errors. I have also tried searching for solutions across forums for th

Bitly API v4 - VBA Excel Macro

I'm trying to get the shorten bit.y URL in my excel file, but instead I'm obtainig the following message, {"created_at":"2022-05-04T21:48:32+0000","id":"bitly.i