| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.PrintTitleRows
Hello! I am having trouble with getting .PrintTitleRows to take a variable I
create that is equal to the row number I need. So instead of having: .PrintTitleRows="$1:$1" row_num = ActiveCell.Row With ActiveSheet.PageSetup .PrintTitleRows = row_num & row_num only this does not work!! Any suggestions? Thanks in advance. -- Dr. M |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.PrintTitleRows
row_num & row_num produces "11". One way:
.PrintTitleRows = ActiveCell.EntireRow.Address In article , "Dr. M" wrote: Hello! I am having trouble with getting .PrintTitleRows to take a variable I create that is equal to the row number I need. So instead of having: .PrintTitleRows="$1:$1" row_num = ActiveCell.Row With ActiveSheet.PageSetup .PrintTitleRows = row_num & row_num only this does not work!! Any suggestions? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.PrintTitleRows
Hi
Try ..PrintTitleRows = "$" & row_num & ":" & "$" & row_num Doug Dr. M wrote in message ... Hello! I am having trouble with getting .PrintTitleRows to take a variable I create that is equal to the row number I need. So instead of having: .PrintTitleRows="$1:$1" row_num = ActiveCell.Row With ActiveSheet.PageSetup .PrintTitleRows = row_num & row_num only this does not work!! Any suggestions? Thanks in advance. -- Dr. M |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| .PrintTitleRows | Excel Discussion (Misc queries) | |||
| Need to read number of PrintTitleRows currently set | Excel Programming | |||
| Can PrintTitleRows method be restricted to a region instead of the whole worksheet ? | Excel Programming | |||
| how high is my PrintTitleRows | Excel Programming | |||
| PrintTitleRows | Excel Programming | |||
Linear Mode
