Thread: Need to read number of PrintTitleRows currently set
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
  
Posts: 430
Default Need to read number of PrintTitleRows currently set
Thanks Vasant, much appreciated.

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
?Range(ActiveSheet.PageSetup.PrintTitleRows).Rows. Count
4

--

Vasant

"Jim May" wrote in message
news:wpFme.21201$Fv.10134@lakeread01...
From my Immediate WIndow I get:
? ActiveSheet.PageSetup.PrintTitleRows
$1:$4

How can I get the integer 4 ?
TIA,
Jim






Reply With QuoteReply With Quote