MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro help


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.


Posted by Russell Hauf on January 15, 2002 1:39 PM

Instead of using goto, just use something like this:

Range(ActiveCell.Text).Select

or

Range("C5").Select

HTH,

Russell