| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I identify matching rows of data and delete them both? | Excel Discussion (Misc queries) | |||
| Using named range to extend print area for variable number of columns | Excel Worksheet Functions | |||
| delete unused columns and grey out the rest area | Excel Worksheet Functions | |||
| print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
| Can you delete all hidden columns in an area in one move? | Excel Discussion (Misc queries) | |||
![Keith Young[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
