Rory

Rory has asked 0 questions and find answers to 84 problems.

Stats

About

Just another Excel junkie.
I inhabit a lot of Excel forums and occasionally mix up the etiquette for whichever one I'm in, so I apologise in advance for that.

Rory questions

Rory answers

VBA Access to Excel export, Error 1004 and 70 when re-running the script
VBA Complicated Getter, Setter syntax
Adding a row to an Excel table using VBA without enabling total row
Insert (and then reference) a picture into Excel using VBA
How do I use the result of an input box in another bit of my code?
Retrieving a comparison operator from cell
Call an Excel macro from a different Workbook
How can using user defined function in custom data validation?
ReDim Preserve error
Trigger a full calculation in VBA