View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Bonallack Daniel Bonallack is offline
external usenet poster
 
Posts: 110
Default Showing activecell in view

The last line of my code selects an entire row
cells(x,1).EntireRow.Select

I had hoped that this row would be in view to the user, but no, the sheet is
left where I last scrolled it to.

Can someone give me a piece of code that will scroll the sheet so that the
highlighted row is in view (if it makes a difference, I have Freeze Panes on
so that Row 1 and columns 1,2,3 are frozen)

Thanks in advance
Daniel