Hi all,
I am beginning to like this VBA stuff, but still a feel like a 4 year old in a math class (and not a brilliant one at that)......
I have looked at earlier postings but failed to solve this one:
Suppose I have merged cells a1:a3 on sheet 1
On sheet 2 I have text strings in cells d1;d2;d3
d1 may be a word, d2 may be a scentence and d3 a small paragraph
Based on a specific condition = true, the merged cell on sheet 1 can be equal to the word, the scentence or the small paragraph.
How do I make the HEIGHT of the merged cell move automaticly so it will fit the text?
Once again, any help is highly appreciated!
Pete
I am beginning to like this VBA stuff, but still a feel like a 4 year old in a math class (and not a brilliant one at that)......
I have looked at earlier postings but failed to solve this one:
Suppose I have merged cells a1:a3 on sheet 1
On sheet 2 I have text strings in cells d1;d2;d3
d1 may be a word, d2 may be a scentence and d3 a small paragraph
Based on a specific condition = true, the merged cell on sheet 1 can be equal to the word, the scentence or the small paragraph.
How do I make the HEIGHT of the merged cell move automaticly so it will fit the text?
Once again, any help is highly appreciated!
Pete
