Results 1 to 3 of 3

Macro to do same as "Go to Blanks" and "Delete Row"

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2008
    Posts
    52

    Macro to do same as "Go to Blanks" and "Delete Row"

    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!)
    1. Select row under last used row in excel sheet
    2. Shift+Ctrl+Down Arrow
    3. Edit > Go to (ctrl+g in '97)
    4. Special
    5. Blanks
    6. [OK]
    7. Edit > Delete
    8. "Delete Entire Row"

    Can anyone give me some keywords, advice, or solutions to do the above in macro form?

    Short Version-
    1. Select all rows under last used cell
    2. Excel UI "Go to" Blanks (whatever that does...)
    3. Delete selected rows

    Thanks!
    Last edited by Luminary Xion; 02-06-2009 at 12:57 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1