You have some code examples in this page:
http://www.rondebruin.nl/tips.htm
Look at the section of Copy/Paste/Merge examples.
Hope this helps,
Miguel.
"Kokopelli" wrote:
I have 65 sheets of data in excel consisting of three columns. I want to
combine all 65 sheets into one long sheet. I am aware that I can just
manually copy each sheet over, however it is a very tedious process and in
the future I may have way too many sheets. I was wondering if there is a
script or something that I can use to quickly combine all of the sheets. thnx
-Rob