Hi,
I am looking for some VBA coding that would do the following:
I have an excel document with two spreasheets, A and B. On spreadsheet B I
am calling for the cell contents (mainly text) from spreadsheet A. The
problem is: when the text is updated in sheet A and becomes longer, whatever
was added in A does not show in B until I expand the cell size in B. How can
I make it so the cell size B adjusts automatically so i can see its full
content? The whole "wrap text" feature does not want since the content is
updated from sheet A (as opposed to directly typed in B).
Thank you so much in advance.
Alec