Hello!
I have the following cell address:
![]()
LastRow = Range("A65000").End(xlUp).Offset(1, 0).Address
What I need is some code that will take the following cell address, lets say that LastRow = A52, select row 52, AS WELL AS the two rows before 52 so rows 50, 51, and 52. Delete these three rows.
I need this to be dynamic so that the LastRow is selected AS WELL AS the two rows BEFORE the LastRow.
Please let me know if you need any clarification!
Thanks!
Bookmarks