PS, Unfortunately I had to log in again to post last message and inadvertently posted an older version from the clipboard. I meant to tell you I'd checked out the link and I think I can assemble a working macro from that, other than the "Excel Object" bit. It does seem to imply that I can have different sets of instructions for different cells. Will look again on Monday.
Excel is so much more complicated to get it to do things automatically than "Enable", a program I used from about 1985 until Y2k! It handled relative cell references in macros better too. I have found that the relative cell tool in 2010 (in macros) has lost capabilities of Office 2000, and have to copy macros in from files created under 2000 to get them to work.
Cheers
Last edited by htieK; 11-01-2014 at 12:37 AM.
Reason: minor spell correct, and minor addition.
|