Re: $$Excel-Macros$$ copy selected range to target with params

2011-08-12 Thread Seba
Hi, thank you for your effort. This kind of macro would help, I would just like to improve on the pasting part. I will try and build on your code. Right now I have to select target sheet and target range for pasting manually. I need to upgrade this so that macro will also select the target apropri

RE: $$Excel-Macros$$ copy selected range to target with params

2011-08-11 Thread Rajan_Verma
See if it helps After select the Range which need to be Copies Press Alt+F8 and Run the Macro Show, -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Seba Sent: Wednesday, August 10, 2011 8:07 PM To: MS EXCEL AND VBA MACROS Subject:

Re: $$Excel-Macros$$ copy selected range to target with params

2011-08-10 Thread Seba
I apologize for insufficient info. I am starting from scratch, but I don't see the option for file upload (where can I upload it?) so I'll try and explain in more detail. My source workbook contains info on several subprojects. From here I need 3 items to be copied: - project number (always locat

Re: $$Excel-Macros$$ copy selected range to target with params

2011-08-10 Thread dguillett1
Post a file with a more complete explanation -Original Message- From: Seba Sent: Wednesday, August 10, 2011 9:36 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ copy selected range to target with params hi, I need help with writing a macro which would copy selected range and