136 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
EDIT: Title changed for clarity. Quick summary: I want to know if the behavior of workbook-scoped, worksheet dependent named formulas (which I will describe…
I am getting an "out of memory" error while trying to name a chart. I need to be able to reference this chart later…
I am attempting to sort column D in ascending order in an excel file with VBA. I would like to expand the selection for…
I have a workbook with multiple modules and multiple subs. There are some variables though that are usesd constantly in most subs such as…
I am working on vba macros. I was trying to use a dictionary. But it is giving error 457 with debugger pointing to toprow.Add…
I am totally new in VBA and coding in general, am trying to get data from cells from the same workbook (get framework path…
I freely admit that I am not too experienced with the HTML Object Library. I have a spreadsheet with IRS Employer Identification Numbers that…
On my 32-Bit PC, running Office 2003 Excel VBA, the following code Debug.Print "" Debug.Print Hex(&HFF00000 And &HF00000) Debug.Print Hex(&HFF0000 And &HF0000)…
I have attempted to add functionality to an excel add-in ave been developing which trims the leading spaces at the end of used cells,…
I have macro, if I put in cell E1 name of the file, macro search trough C:UsersMarekDesktopMakro directory, find it and put the needed…