Go to selected cell in spreadsheet

[paul_taylor]

I thought this was easy but it's not working, so maybe I don't understand it.

I want the macro to end by going to a certain cell in the spreadsheet. I thought all I needed was

cells(100,100).select

But it's showing the top of the spreadsheet and you have to scroll to cells(100,100) but when you get there, the cell is highlighted, it just doesn't open up there.

I want to cells(100,100) to be visible on the screen.

 

[shg]

Maybe

Application.Goto range("CV100"), Scroll:=True

 

[paul_taylor]

That's it. Thanks.