Automatically resizing rows when value changed

Hi, john_london,

if you monitor a cell which has a formula inserted you would need to apply the Calculate-event as that would be triggered on any calculation/change of formula. Workshet_change would need to monitor both cells which might be changed.

You might try to alter the code like

'...
    With AutoFitRng
      .MergeCells = False
      Range(str01).Formula = "=IF(ISERROR(VLOOKUP(Data!$A$39, all_data, MATCH(selected_date, Data!$1:$1, 0), FALSE)), ""n/a"", (VLOOKUP(Data!$A$39, all_data, MATCH(selected_date, Data!$1:$1, 0), FALSE)))"
      Range(str01).Calculate
      CWidth = .Cells(1).ColumnWidth
      MergeWidth = 0
'...

Ciao,
Holger