Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing variable length pages | Excel Worksheet Functions | |||
Variable series length/range | Charts and Charting in Excel | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming | |||
Using a Macro to Sum a Variable-Length Range (a Column) | Excel Programming |