Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > With Activesheet.PageSetup how to set 1st two visible rows as repeat (in VBA)
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 59
Default With Activesheet.PageSetup how to set 1st two visible rows as repeat (in VBA)
2003/2007

With Activesheet.PageSetup how to set 1st two visible rows as repeat
(in VBA)

..SpecialCells(xlCellTypeVisible)?

TIA EagleOne

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 391
Default With Activesheet.PageSetup how to set 1st two visible rows as repeat (in VBA)
Got it.

ActiveSheet.Cells.SpecialCells(xlCellTypeVisible). Row
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Get rid of dotted lines of pagebreak view visible on Activesheet VJ[_2_] Excel Discussion (Misc queries) 1 March 29th 07 11:59 PM
Activesheet.pagesetup Spenceley Excel Programming 2 August 3rd 06 03:21 PM
ActiveSheet.PageSetup.Zoom No Name Excel Programming 1 December 13th 05 10:24 PM
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec unibaby Excel Discussion (Misc queries) 2 August 24th 05 04:29 PM
ActiveSheet.PageSetup.PrintArea variable ? MAS Excel Programming 2 May 2nd 05 05:45 PM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement