Pasted this morning, but not now

C

CLR

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
 
C

CLR

It must be a "Windows thing"......rebooted and all is well.

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

CLR said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncating Ctrl-shift > Edit > CopyPicture 2
Problem copying table data as a picture onto chartsheet 8
Making .jpg's 2
moving excel objects pasted as an image in Powerpoint 1
Sendmail works one computer, not another 0
Macro log 4
How to call out "other" open book 5
Can this code be speeded up? 2

Top