View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Atishoo Atishoo is offline
external usenet poster
 
Posts: 267
Default Go to a specific cell

Application.Goto reference:=Range("bb1"), scroll:=True


"dhstein" wrote:

I want to have a macro that's goes to a specific part of the spreadsheet -
for example BB1. But I want BB1 to be in the left corner of the window. If
I just Select the cell it might not do that. How do I go to that cell and
ensure that the window is correct - the cells to the left of BB1 are not
visible. Thanks for any help on this.