Hi! I am currently working on a project that will copy the first cell or target cell and paste it onto the next cell(s) until it reaches a cell with value. I am actually new in excel programming and i have a little bit of knowledge with. hope to get an answer from this forum. Thank you in advance!
Not much to go on but assuming you target cell is in "A1" and that you want to loop down or by rows, add the following code to the Worksheet module...
Please Login or Register to view this content.
If your questions has been answered to your satisfaction please don't forget to do the following:
Add Reputation ... and ... Mark Thread as Solved
Thanks,
Ma 10:8b Freely you have received; freely give.
Welcome to the forum
Can you upload sample workbook to find solutions quickly?
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi! I don't know why but I can't upload the file so please bear with me. thank you again! so basically, I want to copy the year
2017 and paste it onto the next cell below it until it reaches the year 2018.sample.PNG
Last edited by newguyexcelboy; 03-15-2016 at 10:18 PM.
thank you for your reply. will try it as soon as possible.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks