| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Value in Range then Delete Column
Hi,
I have values in the range C1:J149 on Sheet 2. Via code, I wish to look at the values in the range C1:J1 and if the value is also in the range D27:D34 on Sheet 1, then delete the respective column accomodating that value in Sheet 2. Other Info: Both ranges are dynamic, in that not all cells will have values. eg Sheet 2 Range "C1" = 200535 Sheet 2 Range "D1" = 200536 Sheet 2 Range "E1" = 200537 Sheet 1 Range "D27" = 200535 Sheet 1 Range "D28" = 200536 Result: Sheet 2 Column "C" (200535) deleted. Sheet 2 Column "D" (200536) deleted. All other data in Sheet 2 remains intact. Any help appreciated. Cheers Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete some column headings from an autofiltered range. | Excel Worksheet Functions | |||
| Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
| How can I insert and delete rows within a locked cell range column | Excel Worksheet Functions | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| Delete row from range using key column | Excel Programming | |||
![Ozbobeee[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
