fboehlandt
Active Member
- Joined
- Sep 9, 2008
- Messages
- 334
Hi everyone,
I would like to delete everything in a spreadsheet that lies below row 6. The easiest way to do so using VBA is to use
Rows("7:7").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
selection.delete. However, I would like to avoid the the select statement. Is that possible?
I would like to delete everything in a spreadsheet that lies below row 6. The easiest way to do so using VBA is to use
Rows("7:7").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
selection.delete. However, I would like to avoid the the select statement. Is that possible?