Hi all,
I need to write a macro that copies some data from sheet 1 and pastes it into sheet 2 but in the next free reow in sheet 2.
The bit I am stuck with is how to get the data uinto the next free row in sheet 2.
What command do you use to make it go to the next free / blank row?
Regards BVG
This has been covered so many times on the Forum, a quick search would save you time.
See the contacts form example here
http://excel-it.com/vba_examples.htm
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks