Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Guys,
I have a VBA Macro that works on a sheet and I want to delete from B5 - B17 the problem is that cell A16 is a merged cell (A16 B16 C16) When I use Range("B5:B17).Select it does not select just the cells in column B it selects A5 - C5 down to A17- C17. How can I get it to select only cells B5:B17. If I do it with the mouse directly on the sheet it allows me to do it and ignores the merged cells. Your help is appreciated. Best Regards, Steve Wilson. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting/Clearing duplicate range of cells | Excel Worksheet Functions | |||
MACRO HELP - deleting rows containing a range of blank cells | Excel Discussion (Misc queries) | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
deleting cells in a range | Excel Programming | |||
Deleting Hyphens or Dashes from multiple cells without deleting the remaining content | Excel Programming |