+ Reply to Thread
Results 1 to 9 of 9

Find first empty cell and paste a value

  1. #1
    Forum Contributor
    Join Date
    11-18-2007
    Posts
    111

    Find first empty cell and paste a value

    I want to copy a value in "A1" and i would like to paste it in Column "J" but the problem is that there are some values in column 'J' so i want a code that finds the first empty cell in column "J" and paste in there the value from "A1"
    Can someone help me please...
    Thanks for your time.
    Last edited by karinos57; 02-03-2009 at 07:01 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Find first empty cell and paste a value

    Will a formula do?

    ie. in A1: =LOOKUP(2,1/(J1:J1000<>""),J1:J1000)

    adjust ranges to suit.... can't use J:J in earlier that XL2007
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Find first empty cell and paste a value

    Maybe

    Please Login or Register  to view this content.
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Find first empty cell and paste a value

    ooops... I think I misread the question... ignore my reply.

  5. #5
    Forum Contributor
    Join Date
    11-18-2007
    Posts
    111

    Re: Find first empty cell and paste a value

    may be i was not clear. I want to loop it and check always the first empty cell on column J and paste a new value in there. Thanks

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Find first empty cell and paste a value

    Quote Originally Posted by karinos57 View Post
    may be i was not clear.
    It looks that way.

    Please Login or Register  to view this content.
    So what's looping?

    Can you post an example with expected results

    VBA Noob

  7. #7
    Forum Contributor
    Join Date
    11-18-2007
    Posts
    111

    Re: Find first empty cell and paste a value

    I want to be able to add each time on Column J and when ever i click the Add Button. I am getting error now. If i click add now in the attached file i should see a value on J11 and so on. Pls. see my code and help me. See attached for more details. Thanks.
    Attached Files Attached Files

  8. #8
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Find first empty cell and paste a value

    No need to select.

    If data always in J10 then just use

    Please Login or Register  to view this content.
    VBA Noob

  9. #9
    Forum Contributor
    Join Date
    11-18-2007
    Posts
    111

    Re: Find first empty cell and paste a value

    Thank you so much. It is working now.

+ 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