By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,632 Members | 1,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,632 IT Pros & Developers. It's quick & easy.

Hi, I am having help with a macro and I'm stumped. :(

P: 1
The situation: I am trying to copy a set of cells 'A1 to F40' on a page called 'Confirmation & Shipping' in a macro, and make it paste and save on a separate new excel window.

The main problem is the pasting and saving on a separate sheet part.

I tried in VBA and have even tried in recording the macro myself.

Help me please! Much appreciated.
Mar 26 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 5K+
P: 8,434
The situation: I am trying to copy a set of cells 'A1 to F40' on a page called 'Confirmation & Shipping' in a macro, and make it paste and save on a separate new excel window.

The main problem is the pasting and saving on a separate sheet part.

I tried in VBA and have even tried in recording the macro myself.

Help me please! Much appreciated.
Can you be more specific about how it's going wrong? If you recorded it as a macro while performing the operation yourself, then the code should work, so what is the problem with it?
Mar 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.