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