Thread: Print Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jacqui[_2_] jacqui[_2_] is offline
external usenet poster
 
Posts: 30
Default Print Range


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