Thread: Problems specifying where "freezepanes" occurs using VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Scott Hannon Scott Hannon is offline
external usenet poster
  
Posts: 1
Default Problems specifying where "freezepanes" occurs using VBA
Try using

ActiveWindow.ScrollRow = 1

before your existing code. It's the only way I've gotten it to work
correctly.

Scott Hannon
AL, USA
Reply With QuoteReply With Quote