PDA

View Full Version : Excell 2007 - select all/copy



Abdullah
08-05-2010, 11:37 AM
Hello,

I'm trying to write a macro, and am having an issue with one part of it. I am looking to select all and copy the cells in an excel sheet onto the clipboard, so I can paste all of them into another program's spreadsheet to then graph.

My excel sheet has 180x180 cells in it, all with temperatures. I am hoping to eventually have code that will open all excel files in a folder (there will be about 5,000 of them) one at a time, select all, copy, and then paste into another program that will make individual 3d graphs of the data (again ending up with about 5,000 graphs).

I looked through the kbase and VBA help, but couldn't find code that worked for me, or even really pointed me in the right direction.

Any help would be greatly appreciated.

Simon Lloyd
08-05-2010, 01:30 PM
This will copy everything on the activesheetActivesheet.UsedRange.Copy