View Single Post
  #4   Report Post  
Mladen_Dj
 
Posts: n/a
Default Cell reference problem

Well, just resize sourece cell, to show all text, and picture cell will be
automaticaly resized. I didn't know this before, but that works...


"Jim Olsen" wrote in message
...
This is really cool. I didn't know you could do that.

It's really close to what I want to achieve, but the picture it creates
doesn't show all the text if it's modified later.

For example, if I create a snapshot of the cell which says "Hi There". It
works fine. Change the font, colouring, whatever. It's all good. But If I
add more text to make it "Hi There, how are you going", the rest of the
text outside of the picture box is missed. I can take a new snapshot and
it will show a new larger snapshot, but I'd like to avoid that if I can.

Are there any other ways to get around the problem?