Frequent commenter Alex always has some interesting ideas, and this one didn’t disappoint. If you copy a range, then hold down the Shift key, you will see a Paste Picture Link item under the Edit menu. With this, you can paste a picture onto your worksheet that is linked back to the copied range.
One interesting benefit to this feature is that you can magnify a range.
You can even drag a picture into the range and magnify it.
Then Alex made a workbook where he can drag a shape around, press a button, and magnify the area to which he dragged it.
He has to press a button because the Shape object doesn’t have any decent events to speak of. After reviewing Alex’s workbook, I set out to crash Excel. If a shape, such as a picture, can be shown simply by dragging it into a range, then any shape could be shown in that manner. Hey, the linking object is a shape. I figured if I drag the linking object into the range that is linked, then Excel will spiral into an eternal shape-within-a-shape calculation and crash. No such luck.
Excel survived. Now what I’d like to do is make a magnifying glass that can be drug around and magnify the range directly underneath it. Here are the problems I see:
Picture objects (they’re deprecated, so you won’t see them in the object browser) have a Formula property so they can be linked to a range, but they can’t be made round like a proper magnifying glass.
Picture objects don’t support automation events. That means I can’t trap a move event to recajigger the range to which it is linked.
Even if I could set the range to be below the shape, I can’t stop the shape from appearing in its own representation of the linked range.
To answer your next question: No, I don’t have any use for this. I just thought it would be neat and I’m sure Andy Pope will use some combination of a scatter chart and the BESSELJ function to do it that will blow me away.