zombiemaster
Board Regular
- Joined
- Oct 27, 2009
- Messages
- 245
Hi, All...
Thought this would be easy: mark startRow$ and endRow$, select those rows and delete. But NOOO of course it couldn't be THAT easy...
This is what I tried:
At that point I'm stuck. How do I select the range of row from startRow$ to endRow$ and delete those entire rows?
Feeling like a Monday here...oh yeah, it IS a Monday!
Thanks as always,
~ZM~
Thought this would be easy: mark startRow$ and endRow$, select those rows and delete. But NOOO of course it couldn't be THAT easy...
This is what I tried:
Code:
Range("A100000").Select
Selection.End(xlUp).Select
ActiveCell.Offset(-4, 0).Select
endRow$ = ActiveCell.Row
ActiveCell.Offset(0, 2).Select
Selection.End(xlUp).Select
ActiveCell.Offset(2, 0).Select
startRow$ = ActiveCell.Row
At that point I'm stuck. How do I select the range of row from startRow$ to endRow$ and delete those entire rows?
Feeling like a Monday here...oh yeah, it IS a Monday!
Thanks as always,
~ZM~