John_356
New Member
- Joined
- Jan 17, 2021
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
Good day,
Provided LRR has been successfully defined as last used row,
I've been trying to find a way to delete all rows within my dynamic range (Range ("C2:D" & LRR)) when both cells from same row on columns C and D are blank.
I'm looking for a short and elegant code here
Many thanks in advance,
John
Provided LRR has been successfully defined as last used row,
I've been trying to find a way to delete all rows within my dynamic range (Range ("C2:D" & LRR)) when both cells from same row on columns C and D are blank.
I'm looking for a short and elegant code here
Many thanks in advance,
John