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

 

[Joe4]

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

Not really sure what you mean.
Can you walk us through an example?

 

[mikerickson]

Are you looking for the cell to be auto-sized to fit the result?

 

[ExcelEddie]

Thanks guys so let's just say that...

A VLOOKUP formula in cell A1 has found and shown a text string in cell A1
The text string is too long to show itself in cell A1 and only shows a few words

Can VBA code resize cell A1 so that I can see the full string, without removing the original VLOOKUP formula.

Image 1 shows the formula that searches for and shows the text string in image 2
The text string is much longer than shown in image 2

Hope that helps

Eddie

 

[ExcelEddie]

Are you looking for the cell to be auto-sized to fit the result?

I am yes please

 

[ExcelEddie]

Not really sure what you mean.
Can you walk us through an example?

I have tried using Range("A1").EntireRow.AutoFit but this does not want to resize the cell, I think this is due to the cell actually holding a formula and not the text that was loaded via the formula.

 

[Joe4]

If you want to AutoFit the column, you need to use "EntireColumn", not "EntireRow", i.e.

Range("A1").EntireColumn.AutoFit

 

[ExcelEddie]

If you want to AutoFit the column, you need to use "EntireColumn", not "EntireRow", i.e.

Range("A1").EntireColumn.AutoFit

Yeah, got that thanks however... this widens the cell in question, and this is not an option I really need to the cell's height to change and not the width.

If this is not possible then so be it

Thank you for you your time Joe

 

[mikerickson]

If you want the height to be changed Range("A1").EntireRow.AutoFit if you want the width to be changed Range("A1").EntireColumn.AutoFit

 

[Joe4]

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?