Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasted this morning, but not now
Hi All....
This morning I ran the macro containing the below code, 130 times and it functioned perfectly.....now it fails every time with a "cannot paste" error......I havent changed the macro.......any ideas what might could be wrong? Range("A1:P42").Select Range("p42").Activate Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap Workbooks.Add ActiveWindow.Zoom = 50 ActiveSheet.Pictures.Paste.Select TIA for any help Vaya con Dios, Chuck, CABGx3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasted this morning, but not now
It must be a "Windows thing"......rebooted and all is well.
Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All.... This morning I ran the macro containing the below code, 130 times and it functioned perfectly.....now it fails every time with a "cannot paste" error......I havent changed the macro.......any ideas what might could be wrong? Range("A1:P42").Select Range("p42").Activate Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap Workbooks.Add ActiveWindow.Zoom = 50 ActiveSheet.Pictures.Paste.Select TIA for any help Vaya con Dios, Chuck, CABGx3 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasted this morning, but not now
"CLR" wrote: Hi All.... This morning I ran the macro containing the below code, 130 times and it functioned perfectly.....now it fails every time with a "cannot paste" error......I havent changed the macro.......any ideas what might could be wrong? Range("A1:P42").Select Range("p42").Activate Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap Workbooks.Add ActiveWindow.Zoom = 50 ActiveSheet.Pictures.Paste.Select TIA for any help Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
something happened to all my work from this morning | Excel Discussion (Misc queries) | |||
Time - By 8am the next morning | Excel Discussion (Misc queries) | |||
Ran last Friday, doesn't this morning! | Excel Programming | |||
Saturday morning cut and paste help | Excel Discussion (Misc queries) | |||
Morning | Excel Programming |