
July 30th, 2003, 02:58 PM
|
|
Junior Member
|
|
Join Date: Jul 2003
Location: Atlanta, GA
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Relative References in VB Macros
I want to use the macro writer to write a little program that inserts the current date behind a cell, as a comment. I can record the macro, no problem (It even picks up the Ctrl-semicolin shortcut for the date), but I can't get it to run in any other cell but the one I created the macro in.
I know the solution is to use relative references, but the little checkbox to do this (when creating the macro) is gone. So, how do I modify the macro to use relative references? And why in heavens did they remove that check box!?
Thanks in advance for the help.
|