How to record macro with relative addressing in Excel 2000
Attempt to record a macro with relative addressing. I have R1C1 option
checked in Toolsoptionsgeneral. After recording a simple macro,
addressing is always absolute. I do not know how to program in visual basic.
|