tinderbox22
Board Regular
- Joined
- Mar 9, 2010
- Messages
- 56
- Office Version
- 365
- Platform
- Windows
Hi,
I'm attempting to find multiple instances of a specific text string and then delete and shift cells up. However, if I use the .UsedRange property, there are instances of that same string that I do not want to delete. Is there a way to specify a range rather than using .UsedRange, when finding a cell address? When trying this, I get errors.
My cheat solution is to take my desired range to another blank worksheet, which is not ideal but doable.
Thanks in advance.
I'm attempting to find multiple instances of a specific text string and then delete and shift cells up. However, if I use the .UsedRange property, there are instances of that same string that I do not want to delete. Is there a way to specify a range rather than using .UsedRange, when finding a cell address? When trying this, I get errors.
My cheat solution is to take my desired range to another blank worksheet, which is not ideal but doable.
Thanks in advance.