| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Activesheet.Paste does OK manually between worksheets but not in M
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I name a picture as I paste it from VBA? (ActiveSheet.Past. | Excel Discussion (Misc queries) | |||
| ActiveSheet.Paste (error) | Excel Worksheet Functions | |||
| ActiveSheet.Paste - Error help? | Excel Discussion (Misc queries) | |||
| Can you sort worksheets other than manually? | Excel Discussion (Misc queries) | |||
| Working with Macros-Activesheet.Paste | Excel Discussion (Misc queries) | |||
Threaded Mode
