Target.Address wont triger AutoFit code in Excel 07

[Cheek]

Hi, Im trying to get rows to autofit every time cell b5 changes. Tried several things but still can't figure it out. Thanks

In Cell b5, there is a drop-down list via data validation. The data in the range of B10:E61 will automatically change referencing to the same location of another worksheet specified in the drop-down list of b5.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$b$5" Then
Rows("10:61").Select
Rows("10:61").EntireRow.AutoFit
End If
End Sub


Thanks

 

[Colin Legg]

Just for MrExcel members' reference, this question was asked and resolved on another forum:

http://www.dbforums.com/microsoft-e...ress-wont-triger-autofit-code-excel-07-a.html