Print area changing with input

**Fast Forward** · 10-06-2007, 08:08 AM

I have a sheet that I would like the print area to change vertically based upon user input from (2) different cells. I have attached the sheet with the basic print macro in it, but I don't know how to return the data from the user input to adjust the print area.

Any help would be greatly appreciated.

**Simon Lloyd** · 10-06-2007, 11:23 AM

Hi, i haven't looked at your example but to set a print area by putting cell addresses in seperate cells you can use the code below:

Please Login or Register  to view this content.

**Fast Forward** · 10-06-2007, 06:34 PM

Simon:

Thanks for the reply. I'm one step closer.

In my example I am trying to get the print area to change vertically depending upon input from cells AB2 and AB3. I would like the print area to print from column J to column AB always, but adjust vertically by looking at column K based upon input from cells AB2 and AB3. Some dates in column K are repeated, so it would need to look for the first instance and the last instance.

I apologize if I can't explain it thorough enough. It probably is easier to understand when looking at the example.

Thanks,

Randy

**Simon Lloyd** · 10-07-2007, 06:46 AM

How about something like this:

Please Login or Register  to view this content.

**Fast Forward** · 10-07-2007, 09:17 AM

Thanks Simon, the filtering portion works great, vertically. I have been making spreadsheets for years, but have not dabbled into the macro portion of it (other than recording one). I am just starting to get a drift on some of the commands. This filter works great. Now I just need to know how to combine this with fixing the print area horizontally at columns "J" & "AB" and then set the print area to all of those parameters.

Please Login or Register  to view this content.

Thank you.

**Fast Forward** · 10-07-2007, 05:32 PM

I went to Rule #5, not sure how to show the tags. I did however attach the updated sheet with the macro in it.

Thanks.

**Dav** · 10-07-2007, 06:28 PM

Not an elegant solution but the following works if both the dates exist

Regards

Note I have put in print preview, you can change it to the other line below when you are happy it works

Dav