Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print range won't print | Excel Discussion (Misc queries) | |||
Print range | Setting up and Configuration of Excel | |||
Print Range | Excel Discussion (Misc queries) | |||
Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
Print Range | Excel Worksheet Functions |