typing in a new cell and carrying the formatting of the previous c
You need an event macro for that, something like this one:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 Then _
Target.NumberFormat = Range("A1").NumberFormat
End Sub
Post if you need help to install it!
--
Regards!
Stefi
fadwa ezt *rta:
how can i get the formatting done automatically in line with formatting of
the same row evertime i type in a new cell in that row? for example, i have
data in spread across A1:E1, and there is a special formatting for this set
of data, when i type into F1 i want the same formatting to carry forward.
what i am looking for is not a "paste formating" or "Format Painter" option.
|