If you want for column B then modify my macro to
If Target.Row 4 and target.column=2 Then Rows(Target.Row).Hidden = True


--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
Yes, for instance if I enter data into A2 then row 2 would br hidden but
not
if I enter data into B2 etc.

"Don Guillett" wrote:

specific cell????? Do you mean a specific column within the row?? If so,
which one???

--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
Thanks Don.

How would I make the row hidden by entering data in a specific cell.

Roy

"Don Guillett" wrote:

right click sheet tabview codecopy/paste thisSAVE
Now when you enter anything in any cell in rows (below row 4), the
row
hides

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 4 Then Rows(Target.Row).Hidden = True
End Sub


--
Don Guillett
SalesAid Software

"RobRoy" wrote in message
...
I wish to be able to automatically hide a row when data is entered
into a
cell in that row.
Any ideas?

Roy