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!
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
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,592
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,050
Messages
5,569,891
Members
412,298
Latest member
dietitiann
Top