View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Set position of non frooze rows when panes are frooze

Hi Aron

ActiveCell.End(xlUp).Offset(1, 0).Select

// Per
"Aaron" skrev i en meddelelse
...
I have a macro running with sheets that have panes frooze, lets say row one
is frooze. At the end of the macro the activities of the macro are such
that
the first visible row after one is say row six (2-5 have gotten rolled up
behind frozen row one) How do I say at the end of my code "Next row after
frooze pane that is visible is row 2"?