View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Young[_2_] Keith Young[_2_] is offline
external usenet poster
 
Posts: 2
Default Identify and Delete all Rows and Columns NOT in Print Area

Basically , I am trying to figure a way to identify and delete entire rows
and entire columns that do not intersct with the print area on a given
sheet.

For example, the print_area on Sheet1 is set to E3:J36. I would need code
to delete Rows 1 and 2 and also Rows 37 through 65536. In addition, Columns
A,B,C,D and Columns K through IV need to be deleted.

Is there a way to do this using the Intersect, or any other method?

Thanks in advance. Using Excel 2002.

Keith