Visually select cells using VBA

[JMWeaver]

I would like to go to a particular cell in Excel once some VBA code has finished running. I have used Range("A123").Select (and tried .Activate) but the window (which has frozen panes) stays down at line 2,000 even though A123 is active. How do I get the window to physically display the selected cell on line 123?

 

[Weaver]

application.Goto range("AA123")

Possibly?

 

[JMWeaver]

Afraid not. Does the same as the code I had originally ie selects the cell but sheet stays down at line 2,000 for some reason.

 

[snowblizz]

Try adding the last parameter as shown in this snippet from Excel help.

<code>Application.[B]Goto[/B] Reference:=Worksheets("Sheet1").Range("A154"), scroll:=True</code>

 

[JMWeaver]

Yes, that does the job, thanks a lot!