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.
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.
Maybe
VBA Noob
Please Login or Register to view this content.
_________________________________________
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 !!!
ooops... I think I misread the question... ignore my reply.
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
It looks that way.Originally Posted by karinos57
So what's looping?Please Login or Register to view this content.
Can you post an example with expected results
VBA Noob
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.
No need to select.
If data always in J10 then just use
VBA NoobPlease Login or Register to view this content.
Thank you so much. It is working now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks