View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default set print area for variable number of columns

What criteria needs to be used inorder to establish the number of
columns that need to be set in the print area?
CAB horse wrote:
Excel 2002
Hi I want to create a macro to set the print area on a worksheet where the
number of columns will vary. I've tried adapting the advice on setting for
variable rows but get run errors, usually 424. My knowledge of VBA is not
good so please could you keep it simple for me.
Many thanks