Hi,

I'm trying to come up with a piece of macro code to add to a current macro associated with a form control button. This additional piece of code is to set the print area according to what data is there, and then print the current sheet.

I want the print area to be columns G:J and from row 2 to the last piece of data in the list. I already have a piece of code in there, that is using the last row information.

Please Login or Register  to view this content.
I think because of this, my efforts so far are not working.

Any help would be appreciated.

P.S. x-reference at http://www.mrexcel.com/forum/showthr...=1#post2052321