AppleScript for Excel to select/copy all cells?

Solution 1:

found this on Macscripter.net I think it is what you are looking for:

tell application "Microsoft Excel"
   tell active sheet
       select used range
   end tell
end tell