Deleting Rows
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Deleting Rows

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi all

    Bit of a problem i hope someone cn help with.

    I want to deleted all rows within a workbook (multi sheets) where column j has no values.

    I'm able to do each sheet one by one by Selecting column j then Edit/GoTo/Special/Blanks followed by Edit/Delete/Entire Row. However, I'm sure it would be possible to do all sheets in one hit maybe by using a macro?

    Ta

    Lee


  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Record the macro. I plan to have the instructions for recording in Excel soon, but they're very similar to these instructions for recording in Word. The difference is that with Excel, you assign a toolbar button AFTER you create the macro.

    Go here:

    http://www.thewordexpert.com/wordvba...ToRecordAMacro
    ~Anne Troy

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks for that. I've recorded the macro against the 1st sheet in my workbook. Could you please tell me what code I have to append to the end of the macro to force Excel to move on to the next sheet, and the next etc until it completes the last one. Apolgies for sounding so naive!

    Regards

    Lee

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com