Excel Macro
Excel Macro
(OP)
Hi
I need to write a macro to copy a range of cells in a range say "A1:J2000" in a worksheet and paste it to a new file in a particular folder in my desktop.
Could you tell me what command I need to use and How I do it?
Thanks!
BigB
I need to write a macro to copy a range of cells in a range say "A1:J2000" in a worksheet and paste it to a new file in a particular folder in my desktop.
Could you tell me what command I need to use and How I do it?
Thanks!
BigB
RE: Excel Macro
open the file
Start the "macro recorder"
Allways the same cells?:
Leave the "button" "relative reference" off
Relative to current positin?
set the "button" "relative reference" on
Do what you wish the macro to do and press "stop" when finished.
Open the VBA editor and edit anything you want (e.g. range or filename)
Best Regards
Morten