Get value of pagesetup.printtitlerows from excel to userform

[crabback]

Hi
Can anyone tell me if it is possible, and if so, how do I get the current value of the printtitlerows in Page setup to read into a variable in my userform?
I can send a value from my userform to set the printtitlerows, but I can't seem to get the value read back into my form.

Thanks



Crabback

 

[PHV]

Something like this ?
MsgBox ActiveSheet.PageSetup.PrintTitleRows

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[crabback]

Thanks PHV
Thats what I thought. I tried it yesterday before I went home, but I was putting it in the wrong part of my code so it didn't work.

Thanks

Crabback