J
jacqui
I'm setting my Print Range with the following code
Range("A" & iRCount, Cells(iRFin, iCCount)).Select
Selection.Name = "PrntRnge"
then in my Print Sub I refer to the print range as follows
ActiveSheet.PageSetup.PrintArea = PrntRnge
When I step through code PrntRange = ""
(FYI - variable is set to string)
Where am I going wrong, can anyone help?
Many thanks
Jacqui
Range("A" & iRCount, Cells(iRFin, iCCount)).Select
Selection.Name = "PrntRnge"
then in my Print Sub I refer to the print range as follows
ActiveSheet.PageSetup.PrintArea = PrntRnge
When I step through code PrntRange = ""
(FYI - variable is set to string)
Where am I going wrong, can anyone help?
Many thanks
Jacqui