+ Reply to Thread
Results 1 to 11 of 11

removing blank rows by macro

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    removing blank rows by macro

    Hi guys

    Im looking to remove blank rows that have no data in within rows 22-40.
    The thing is they technically have something in the cell as they have a formula in them which populates from another sheet.
    so in sheet quote cell a22 I have the following formula ='Input Page'!C6

    so if cell input page c6 is empty then so will sheet quote cell a22 excluding the formula

    is there anyway I can delete these rows by macro if the rows are "empty"

    thank you

  2. #2
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: removing blank rows by macro

    Pick one column that you consider empty and use that as a reference to delete the row.

  3. #3
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: removing blank rows by macro

    don't understand what youre trying to say

  4. #4
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: removing blank rows by macro

    Pick one of the cells in the row that you consider to validate the row as having data. Use that as a starting point.

  5. #5
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: removing blank rows by macro

    For example:
    Please Login or Register  to view this content.

  6. #6
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: removing blank rows by macro

    Maybe:

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: removing blank rows by macro

    neither works guys

  8. #8
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: removing blank rows by macro

    what has column c to do with it? im lost?
    column c will always be empty

  9. #9
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: removing blank rows by macro

    Column C was an example. You will determine which column.

  10. #10
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: removing blank rows by macro

    Can you post a sample file, with some dummy data which does respond to the macros provided?

  11. #11
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Stockholm, Sweden
    MS-Off Ver
    Excel 2003, Excel 2007 & reluctant Excel 2010 user
    Posts
    4,585

    Re: removing blank rows by macro

    Assuming that you got headings in cell A1 and in the rows you got formulas the formula value is 0 if there is no value in the "Input page" you could test a macro like this.

    Please Login or Register  to view this content.
    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Removing Haning Blank Rows
    By willhh3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-10-2015, 02:07 PM
  2. Removing rows that appear to have blank cells
    By pr1m35 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2010, 06:42 PM
  3. Removing Blank Rows from a Spreadsheet
    By kdeal in forum Excel General
    Replies: 1
    Last Post: 07-17-2007, 09:25 AM
  4. Removing blank rows
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-20-2006, 07:55 PM
  5. Removing Blank Rows
    By inveni0 in forum Excel General
    Replies: 4
    Last Post: 02-05-2006, 06:15 AM
  6. Removing blank rows
    By Carlton Patterson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2005, 07:05 AM
  7. [SOLVED] Removing blank rows
    By in forum Excel General
    Replies: 2
    Last Post: 03-15-2005, 11:51 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