+ Reply to Thread
Results 1 to 6 of 6

VBA - Why isnt this working?

  1. #1
    Registered User
    Join Date
    06-24-2008
    Posts
    98

    VBA - Why isnt this working?

    I cant work out why this isnt working. Any help would be gr8!
    The first one works fine but the "Description" and "Customer" paste over the top of each other and dont find the empty cell. im sure im missing something!

    This submits the following details into the "Stored" table. It also finds an empty cell.

    Please Login or Register  to view this content.
    Last edited by Chris424; 10-28-2008 at 10:24 AM. Reason: add code tags

  2. #2
    Registered User
    Join Date
    06-24-2008
    Posts
    98
    Anyone?

  3. #3
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387
    Chris424,

    Your code works for me. It finds the first empty cell in columns B, C, D, and copies the values from the sheet "Other".

    Please Login or Register  to view this content.

    Can you attach a sample of your workbook?


    Have a great day,
    Stan

  4. #4
    Registered User
    Join Date
    06-24-2008
    Posts
    98
    Thank you for replying. I have attached the worksheet.

    Would someone take a look?
    Attached Files Attached Files

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,466
    Try this,

    Please Login or Register  to view this content.
    When using each column to determine end row it will get out of sync if there are any blanks.
    Cheers
    Andy
    www.andypope.info

  6. #6
    Registered User
    Join Date
    06-24-2008
    Posts
    98
    Quote Originally Posted by Andy Pope View Post
    Try this,

    Please Login or Register  to view this content.
    When using each column to determine end row it will get out of sync if there are any blanks.
    Thankyou, thankyou!! It works. Im really pleased! Thankyou!

+ Reply to Thread

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