AgentMeow99
New Member
- Joined
- Oct 15, 2015
- Messages
- 19
This is the last item for my macro and I am hoping you can help me - PRETTY PLEASE??
The below code selects row 6 until the last line with data. I need it to go to my last line of data PLUS one more row, and then delete the chosen rows. Can you help me? After this one thing I am done with my task. Thank you in advance!
Sheets("Journal Report").Select
Rows("6").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveWindow.SmallScroll Down:=3
Selection.Delete Shift:=xlUp
The below code selects row 6 until the last line with data. I need it to go to my last line of data PLUS one more row, and then delete the chosen rows. Can you help me? After this one thing I am done with my task. Thank you in advance!
Sheets("Journal Report").Select
Rows("6").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveWindow.SmallScroll Down:=3
Selection.Delete Shift:=xlUp