Dear all,

I found that the paste picture link feature is useful. Can I create a link picture that can be
change by function?
Like =IF(A1="USA","show a cell's link","nothing")
If the cell A1 is USA, the picture link will show the content of B1 to C1, if not, show nothing?

Thanks for your help.

K.Parker

I think you would have to make B1 to C1 not show anything. The picture link
reflects the linked worksheet. As far as I know you can't edit the linking
formulas if formulas are used (which i doubt).

--
regards,
Tom Ogilvy

"K.Parker" wrote in message
...
Dear all,

I found that the paste picture link feature is useful. Can I create a
link picture that can be
change by function?
Like =IF(A1="USA","show a cell's link","nothing")
If the cell A1 is USA, the picture link will show the content of B1 to C1,
if not, show nothing?

Thanks for your help.

K.Parker