View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mcphc mcphc is offline
external usenet poster
 
Posts: 44
Default Find print area when no print area set

I have a worksheet that is shown in page break preview view.

The heavy blue outline shows the boundary of what is shown in a print preview.

There is no print area set. I would like a macro that would find the address
of this blue boundary and set it to the print area.

How can this be done?

Thanks