OP Reposted question Row Height with Links

[excellooser]

Using 2003, I am linking cell text from one sheet to another with the =PageName!CellNumber formula. I have the receiving page's row-height set to AutoFit, but when I enter text in the sending cell the receiving cell does not change size. I have to go to the receiving page and do the AutoFit fuction after entering in text on the sending page, which is a drag.
Anyone know a fix so that the receiving cell in a link will really AutoFit to match the incomming text?

Thanks

[excellooser]

just a bump before i give up

[olasa]

I think you will need a small VBA script, that is triggered by a change in the cell.
Try post this in the Programming forum
//Ola

[excellooser]

Thanks! I'll do that.