vba code for a camera copy

[Giordano Bruno]

Does anyone know the vba code to make an Excel "camera copy". When I try to record the macro, the camera copy does not work.

 

[Weaver]

What's a 'camera copy'? Do you mean the Windows 'print scrn' function? Or is this some hidden Excel trick I've not heard of?

 

[Andrew Poulsom]

It's the same as Edit|Copy then Shift+Edit|Paste Picture Link:

Selection.Copy
Range("B13").Select
ActiveSheet.Pictures.Paste Link:=True

 

[Giordano Bruno]

Andrew,

Many thanks. I'd been looking everywhere for that. Should have tried here first.

Hi, XLR8R. Looks like it's a new trick!