Hello

I have read through various threads and found what I need but canno
pull it together due to inexperience.

I am trying set up the print area to adjust according to the number o
rows in a sheet. The rows change depending on what the sheet use
selects but the columns always stay constant. I have looked a
usedrange however it picks up the formatted cells so prints blan
pages.

Is there a way that I can add a count into the string below??
In the active sheet that I am printing there is an index in column
that I could search for the last entry and add 3 rows which would the
print everything. However there are blanks within column d

ActiveSheet.PageSetup.PrintArea = "$b$3$am$" & countsomething & ""


Any help appreciate

--
Kstalke
-----------------------------------------------------------------------
Kstalker's Profile: http://www.excelforum.com/member.php...fo&userid=2469
View this thread: http://www.excelforum.com/showthread.php?threadid=57125