Activesheet.Paste does OK manually between worksheets but not
Hi again Billy,
I need all the code from where you select, copy and then paste it. I am
assuming there is something wrong in the selecting/activating of
windows/worksheets.
--
Regards,
OssieMac
"Billyruben" wrote:
Hey Ossie
This is what the Macro generated sans the standard lines:
Range("C4").Select
ActiveSheet.Paste
Running the Macro through from the begining, however, produces an error.
(Again the data to be copied resides (originates) in a different
worksheet(A). But as stated, doing a manual Paste into an worksheet(B) works
fine and even generates a Macro. It's when Running the Macro that the thing
falls apart.)
Thanks
"OssieMac" wrote:
Hi Billy,
A picture is worth a 1000 words. Likewise a sample of the code. Would you
like to post the recorded code.
--
Regards,
OssieMac
"Billyruben" wrote:
Background: An area containing data is manually hi-lited and designated for
copying into WorkSheet A (W/S-A). W/S-B is the intended destination.
Under the manual mode, the selected area is pasted into W/S-B without a hitch.
The paste process in W/S- B was carried out while a Macro was being recorded.
When the Macro was subsequently Run, it failed at Activesheet.Paste
Question: Why does the process work manually, but not from a Macro?
|