Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print variable page sizes
I have a sheet that varies in number of lines I want to print. Number o columns is constant. The number of lines is found by adding 20 to the highest number i column A, where a list of items from 1 to x starts in A6. Eg. if x = 1 the area to print is from A1 to N37. I will need VBA to find out what the value of MAX(A:A) is. How is thi done? The meaning is perhaps easiest understood by following sentence, whic unfortunately does not make sense to VBA: ActiveSheet.PageSetup.PrintArea = "A1:N(MAX(A:A)+20)" NS -- ns ----------------------------------------------------------------------- nsv's Profile: http://www.excelforum.com/member.php...fo&userid=2650 View this thread: http://www.excelforum.com/showthread.php?threadid=53746 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 appears to only allow you to use specified page sizes | Excel Discussion (Misc queries) | |||
sorting+variable cell sizes | Excel Discussion (Misc queries) | |||
are page sizes defined anywhere? | Excel Discussion (Misc queries) | |||
how do I add another page with different cell sizes? | Excel Worksheet Functions | |||
Custom page sizes in Excel | Excel Discussion (Misc queries) |