Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Print Area question
I have a spreadsheet that has a varying number of rows to print depending on
the amount of data. The columns are standard A:F but the rows could be 3 or 33. I have had a couple of goes but can't get it to play. Columns F have data but don't print. The cells after the last non blank have formulas that return "". So, what I need is a code that will set the print area as A1:the last non blank cell in Column F but not detect the formulas returning "" below the last non blank. Currently I have the print settings set to return [page]of[pages] as a footer and A1:F1 at the top of each page. Am I correct in assuming that specifying the print area won't alter those settings? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
File, print area, clear area, is not working | New Users to Excel | |||
print area across the freeze panes area | Excel Worksheet Functions | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) |