Results 1 to 3 of 3

VBA: inserting blank cells

Threaded View

Flabbergaster VBA: inserting blank cells 11-03-2010, 07:26 AM
Domski Re: VBA: inserting blank cells 11-03-2010, 07:53 AM
Flabbergaster Re: VBA: inserting blank cells 11-03-2010, 08:09 AM
  1. #1
    Registered User
    Join Date
    10-28-2010
    Location
    Denmark, Europe
    MS-Off Ver
    Excel 2010
    Posts
    62

    VBA: inserting blank cells

    Hi
    It should be an easy task I assume, but I just can't get my head around it.
    I need to write a macro inserting 2 empty cells/ moving the other cells in the row 2 columns to the right every time the cell in column A is empty.

    ----A---B---C---D---E
    1--x----x---x---x----x
    2--------x---x----------- (these x's should move 2 places to the right)
    3--------x---x----------- (these x's should move 2 places to the right)
    4--------x---------------- (these x's should move 2 places to the right)
    5--x----x---x---x----x
    6--------x---x----------- (these x's should move 2 places to the right)

    What I want to do is automatically move the values in rows beginning with an empty spot two places further to the right; in this example it would be row 2, 3, 4 & 6
    And afterwards I want to do almost the same thing, now just moving the cells 1 place to the right, if the cell in column E is empty; as E4 in this example.

    ----A---B---C---D---E
    1--x----x---x----x---x
    2------------------x---x
    3------------------x---x
    4------------------x----- (this x should move one place to the right)
    5--x----x---x---x----x
    6------------------x---x
    Last edited by Flabbergaster; 11-03-2010 at 08:15 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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