Autofit a column width as a result of a search formula

[A440]

Hi,
I have a formula that searches another sheet for song lyrics " =IF(K$8="","",INDEX(Lyrics!A:AAA,ROWS($1:4),K$8)&"") ", what I would like to happen when I enter a new search is the column width to auto fit the widest cell.

Any help would be greatly appreciated.

File now updated.

[berlan]

Hi,

seems to me the attached workbook is empty. You can try to use a worksheet event (use in the Sheet module with cell K8).

For example,

Please Login or Register  to view this content.

[A440]

Thank you for your reply.
I have updated the file.
I can get your suggestion to work but only by re applying the formula in K8.
I also have another worksheet change event on the same sheet, as a result the procedure names clash, can the name be changed?