Set print area

[colinharwood]

Hi All

I have a macro which finds the last cell with data in in column H and then selects all the cells from there back to A1. I then want the macro to set this as the print area.

Any ideas

Many Thanks

Colin

 

[plettieri]

Have your tried recording 'on' the "record macro" feature, then navigate to the cells you want record,set up for printing, etc......then turn the "macro record" off.. You can the edit the script in the edit macro screen...

does this help.....

pll