View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick Smith[_2_] Nick Smith[_2_] is offline
external usenet poster
 
Posts: 43
Default 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