What I'm trying to do is copy data from a horizontal list, paste it into a column on a different sheet and repeat until there is no more data to copy. The code shown is just a fragment.
Is this possible, or is there a better way?
Please Login or Register to view this content.
Thanks in advance!
Try this instead, it's untested but it should copy the Rows to successive columns in the other sheet
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
No luck with that. I keep getting object errors at this line:
Anyone have other ideas?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks