sorry to confuse: it controls the other fields in that row only, B6 controls
row 6 population, B7 controls row 7 population, etc.

your code works nicely with B, and I even made an "unhide" variant to
reverse it if needed by changing the final conditional to "If .Cells(X,
"B").Value = 0 Or .Cells(X, "B").Value = "" Then
.Cells(X, "B").EntireRow.Hidden = False"
works wonderfully now to Hide and UnHide, many thanks!

"Rick Rothstein (MVP - VB)" wrote:

yeah, what happens is the data from that field is on another sheet...field
B5
checks that other sheets to see if it =$0.00, then B6 checks is B5 "" B7
checks if B5"" and so on. I know there are quicker ways to populate it,
but
I'm a bit oldschool Quattro...which is why I am learning this stuff to
make
Excel better than my other sheets used to be. :)

So if I change your code to read B it should work on my original cell
reference for ""?

I'm still a little confused. Are you saying that ONE SINGLE cell (B5) in the
other sheet controls whether EVERY row in your data on the current sheet is
displayed or not? Every row??? If that is not what you are saying, then you
will need to tell us how to identify which rows of data on the current sheet
are linked into B5 on the other sheet and which are not.

Rick