I am trying to reference a cell in another worksheet that is formatted to
'autofit' and 'wrap text', but when the information of the original cell
translates to the destination cell, it loses its 'autofit' and 'wrap text'
format. Someone suggested the following, but I am still not having any luck
unless I am applying the code incorrectly.

Right-click the sheet tab, select View Code, enter this:
Private Sub Worksheet_Change(ByVal Target As Range)
Rows(Target.Row).AutoFit
End Sub

HELP!!!

Bermi Girl