Printing Variable Length (but Not Width) Range
 

My report includes a variable number of securities. I have two name
cells at the bottom of the report: one cell has a formula tha
calculates the bottom row number of the report and the other cell has
formula that calculates the row number 11 rows up from the bottom.
want to print these last 11 rows (the columns of interest are fixed).

I will paste several of my failures below. Several of these woul
compile OK, but printed the entire SS.

'ActiveSheet.PageSetup.PrintArea = Range(Cells(81, 3), Cells(92
12))
'ActiveSheet.PageSetup.PrintArea = "R81C" & "3" & ":" & "R92C"
"12" & ")"
'ActiveSheet.PageSetup.PrintArea = "="R81C" & "3" & ":" & "R92C"
"12"""
'ActiveSheet.PageSetup.PrintArea = "R81C3" & ":" & "R92C12"
'ActiveSheet.PageSetup.PrintArea = ""R81C3" & ":" & "R92C12""
'ActiveSheet.PageSetup.PrintArea = "R81C3,R92C12"

Please help.
Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=27580