dim TopRow as long
dim BotRow as long
dim LeftCol as variant 'string or number!
dim rightcol as variant 'string or number

toprow = 1
botrow = 32
leftcol = "C"
rightcol = 92

with activesheet
.pagesetup.printarea _
= .range(.cells(toprow,leftcol), .cells(botrow,rightcol)) _
.address(external:=true)
end with

If this doesn't help, what are your variables and what do they hold?

Richard wrote:

Using variables to hold print ranges. How do I assign variables to
.pageSetup.PrintArea = ???

--

Dave Peterson