Image of an Area

jeffmoseler

Well-known Member
Joined
Jul 16, 2004
Messages
539
I've done this before, I just can't remember how.

I need to create an image of a section of the spreadsheet, that appears in a section of another.

I hope that makes sense!
 

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,590
Hi there

There are 2 ways to do this, depending on whether you want a static snapshot or a dynamic copy that updates when you change the original.

For the former, select the area you wish to copy, hold down SHIFT and select EDIT / COPY PICTURE

For the latter, select the area then click on the CAMERA icon on the TOOLS toolbar.

regards
Derek
 

jeffmoseler

Well-known Member
Joined
Jul 16, 2004
Messages
539
Perfect! This works great!

I do have a followup question though. Can you put a dynamic picture of a worksheet in a user form?
 

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,590
Hi again

Not sure if the camera feature works on userforms. Suggest you post that as a separate question to see if anyone else knows.
regards
Derek
 

Forum statistics

Threads
1,077,831
Messages
5,336,656
Members
399,094
Latest member
Learner2019

Some videos you may like

This Week's Hot Topics

Top