+ Reply to Thread
Results 1 to 4 of 4

move down column and for every blank cell, clear contents of cell to the left

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    79

    move down column and for every blank cell, clear contents of cell to the left

    hello, i need a code that moves down a column and for every empty cell in the column the cell to the left is cleared and then it moves on to the next cell down. the column is not always the same and will start from a selected cell, and the column will contain no more than 5 rows

    thanks for the help!

  2. #2
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: move down column and for every blank cell, clear contents of cell to the left

    Hi,

    Give this code a try...
    Please Login or Register  to view this content.
    Regards,
    Rudi

  3. #3
    Registered User
    Join Date
    10-25-2013
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    79

    Re: move down column and for every blank cell, clear contents of cell to the left

    thanks, that worked great, i just changed the rStart to = activecell

    thanks again

  4. #4
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: move down column and for every blank cell, clear contents of cell to the left

    My pleasure

+ 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] Want to clear contents also from left column
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2014, 02:31 AM
  2. Clear Contents of every other cell in one column
    By norolimfrodo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2011, 12:46 PM
  3. macro to clear contents of two ranges if cell is blank
    By fisher-price in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2011, 10:39 PM
  4. Clear contents of a cell of row A, if cell in row I is blank
    By salventuro in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-07-2009, 01:58 PM
  5. Move contents of selected cell down one, and to the left one cell?
    By Albert Einstein in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-17-2006, 01:20 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