Thread: Need to read number of PrintTitleRows currently set
View Single Post
  #2   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
Actually, I need the number of rows currently set;
I tried
? ActiveSheet.PageSetup.PrintTitleRows.Rows.count
but no luck.
so if it were $3:$8 _ need 6
TIA,
Jim

"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