setting print area
Hi,
Can anyone help me with a macro to search down column A from row 15 onwards
(inclusive) until it finds the last cell containing any text (cell #), and
then set the print area to cells A1:X#, where # is the last cell in column A
containing any text?
Any help with this would be much appreciated!
Thanks in advance,
Nick
|