Strings n things

[ExcelEddie]

Hi all,

I hope this is possible...

I have a formula that loads a text string to a cell
The formula is a VLOOKUP (See below - nothing special)
The text string shows in the cell that contains the formula but only to the pre-determined boundary of the cell
So far, so good

Is VBA clever enough to expand the cell vertically to include the text string found by the formula?

Formula:
=IF(VLOOKUP($C$4,DB!$A:$QD,50,FALSE)="","",VLOOKUP($C$4,DB!$A:$QD,50,FALSE))

Thank you in advance

 

[ExcelEddie]

Do you have the cells set to wrap the text (I think you need this if you want the height to be adjusted automatically)?
Do you have any merged cells on your sheet?

Hi Joe,

I do indeed have wrap text set and yes there are merged cells on the page but not on the cells I need to resize.

I have tried MIke's entirerow.autofit but this doesn't seem to work.

Maybe I need to go about this another way.

Thanks for your help, I'll let you know if I get anywhere.



Eddie

 

[Joe4]

Hi Joe,

I do indeed have wrap text set and yes there are merged cells on the page but not on the cells I need to resize.

I have tried MIke's entirerow.autofit but this doesn't seem to work.

Maybe I need to go about this another way.

Thanks for your help, I'll let you know if I get anywhere.



Eddie

Out of curiosity, if you remove all merged cells, does it work?
Even if they are not in the cells you are trying to change, if they are in the same row or column as the cell you are trying to change, it could interfere with it.