Posted by Steve on January 15, 2002 12:37 PM
I am trying access a particular cell. I know the postion (address command) of the cell I want to access and have pasted it into a cell. Then I copy the cell using ctrl c. Then I type ctrl g to access 'go to' and paste the contents of the clipboard into the refrence box and press enter. This is all stored in a 'key stroke' recording macro. The problem is that it will never update the clip boards contents when I run the macro a second time, it always will goto the original pasted address.