Cell Reference Help

[zalik22]

Hi,

I have a cell that has a string "A2:B3". Is it possible to reference this range in a picture so it displays the cells in A2:B3? Thanks!

 

[offthelip]

Have you tried the INDIRECT function

 

[zalik22]

Yeah but it won't display the range of cells. It works for one cell, can you maybe help me with the formula?

 

[zalik22]

Re: Cell Reference Help for Picture Link

Hi, I am basically trying to update the reference in a picture link so that it displays non-zero data. I have the calculated range in a cell but not sure how to update it in the link. Is there a way to grab the cell contents and use a formula to display the range? For example, cell C5 has "A2:B4" in it, but I don't know how to update the picture link to have the range displayed in cell C5.

 

[FormR]

Re: Cell Reference Help for Picture Link

Hi, try creating a named range called "MyRange" for example that refers to:

=INDIRECT(Sheet1!C5)

And then in your picture refer to =MyRange

 

[zalik22]

Big THANKS! It worked.