Results 1 to 7 of 7

Do Until Cell IsEmpty

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Do Until Cell IsEmpty

    I am trying to break up a bigger question into smaller bit so that I understand the steps.

    I have:

    Cell
    A1 = 1 B1 = 2
    A2 = 3 B2 = 4
    A3 = 5 B3 = 6

    How do I write a code such that

    E1 = A1 and F1 = B1
    Then
    E1 = A2 and F1 = B2
    Then
    E1 = A3 and F1 = B3
    Then
    It stops because A4 is empty.

    I really feel like a baby because I know what I want but find it hard to convey the message, I really hope someone would help me. I had a bigger problem which I had posted earlier but made no progress so I'm breaking down to this bit size first.

    Thanks.
    Last edited by fa888; 10-19-2010 at 11:27 PM.

Thread Information

Users Browsing this Thread

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

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