Image of an Area

[jeffmoseler]

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]

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]

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]

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