Image of an Area

jeffmoseler

Well-known Member
Joined
Jul 16, 2004
Messages
540
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!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
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
 
Upvote 0
Perfect! This works great!

I do have a followup question though. Can you put a dynamic picture of a worksheet in a user form?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,212,058
Messages
6,105,656
Members
447,974
Latest member
misspancake

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top