Application.Goto Help

[clearwaterdave]

Hello,

I have a snipplet:

Please Login or Register  to view this content.

which indeed selects the proper cell but does not jump to it or view it. I would like it to perform as if it were a goto but am confused as to how to code it.

Any help or suggestion would be appreciated.

Thanks.

[jeffreybrown]

Try...

Please Login or Register  to view this content.

[royUK]

You don't usually need to select a cell in VBA to perform an action on it

This will select the last cell with data below B3

Please Login or Register  to view this content.