I'm new to macros and working on a macro to facilitate a function that usually is the following steps-
(Sorry it's long! Short version at bottom of post!)
- Select row under last used row in excel sheet
- Shift+Ctrl+Down Arrow
- Edit > Go to (ctrl+g in '97)
- Special
- Blanks
- [OK]
- Edit > Delete
- "Delete Entire Row"
Can anyone give me some keywords, advice, or solutions to do the above in macro form?
Short Version-
- Select all rows under last used cell
- Excel UI "Go to" Blanks (whatever that does...)
- Delete selected rows
Thanks!
Bookmarks