excel vba to autofit row after cell update

[trevb]

Hi, can anyone help please....basically I have data updated (formula) in column G dependant on what is entered in column C so need to autofit the row that has changed in rows 5 to 95.

Any help greatly appreciated.

[nst1107]

How about something along the lines of:[vba]Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("G5:G95")) Is Nothing Then Exit Sub
Columns("G").AutoFit
End Sub[/vba]