View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Macro to setup Rows to Repeat at the Top

Who are you talking to?

Mine works no matter how many rows you select.

With ActiveSheet.PageSetup
.PrintTitleRows = Selection.Areas(1).Address
End With


--JP

On Mar 19, 12:39*pm, Steven wrote:
That is not what I am looking for. *That works if I want row 1 and 2. *But I
want to go with the current selection top row and bottom row because it will
not always be row 1 and 2 that I want to repeat. *I want to use the current
rows selected.

Thanks,

Steven