Print Range

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top