Results 1 to 6 of 6

Delete rows with blank spaces in column A in multiple worksheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    London
    MS-Off Ver
    Excel 2003 Excel 2010
    Posts
    189

    Delete rows with blank spaces in column A in multiple worksheets

    Hi Sir,

    I created a macro as below trying to delete rows which has empty spaces "" in column A. But the macro failed to work properly.

    Sub RemoveBlankRows()
        Dim ws As Worksheet, allsheets As Worksheet
        Set allsheets = Sheets(Array("Sheet1", "Sheet2", "Sheet3"))
        For Each ws In allsheets
            Range("A1:A100").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
        Next ws
    End Sub
    Can you have a look please? I attached the example file here. Thank you a lot.
    Attached Files Attached Files
    Last edited by alice2011; 08-25-2015 at 08:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to use a macro to remove rows whose values in column A equal to blank spaces?
    By billj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2014, 06:38 AM
  2. Macro to delete blank rows if column I is blank for the row
    By tiger10012 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-10-2013, 03:01 PM
  3. [SOLVED] VBA Find last row and column that contain data and delete all blank rows and blank columns
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2012, 01:07 PM
  4. [SOLVED] How to Delete Multiple Consecutive Blank Rows - Delete all Blank Rows
    By raw_geek in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-16-2012, 03:17 PM
  5. delete blank rows in multiple worksheets
    By pacman76 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-03-2012, 05:55 AM
  6. Delete Rows if cell value in a column are blank
    By excelrequest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2010, 01:30 PM
  7. Delete ALL rows that have cell in Column (J) that looks blank
    By Sanne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2010, 11:10 PM

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