container show other range

Hello all,

Is there available I can add a container in sheet A and the container can shows range of other sheet?

I want add a container in sheet A, the container can show range of sheet B : " =SheetB!A1:D10"

I don't want to simply add link from sheet to sheet, I want the link between sheet and a container.

Thank you!

The container in my word is kind of a control unit, that is not a cell.
the container is an object, it can be revised by VBA program

maybe use Camera tool

looks the camera captured part is a picture like range, it is not able to be edit.


I want to use the same "picture:" show different range when I changed the VBA code. also I can edit the range in the "picture"

So ask moderator to move this thread to the VBA part of forum (use:Report Post from the first your own post)

you're welcome and thanks