I have searched with no luck as to how I may copy the cells A1-C1 and then autofill this data into A2:C using VBA.
The number of rows to Autofill will vary depending on the data I paste.
I have tried the below code with no luck. I'm obviously missing something.
Could someone kindly show me the code I need please?
Please Login or Register to view this content.
Sample01.xlsx
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Have you set Lastrow? Something like this should work:
Please Login or Register to view this content.
Thank you so much. Once LastRow set all worked perfectly. Greatly appreciated.
You're welcome and thanks for the rep!
Glad to hear it worked for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks