Autohide Rows based on condition

[Supriya]

How do I Autohide the rows when there is no entry, & show them when an
entry is made?

 

[Peter Russell]

How do I Autohide the rows when there is no entry, & show them when an
entry is made?

That's a clever concept - entering data into hidden rows-)

Peter

 

[Guest]

cells(row,column)="data" wouldn't have a problem if the row was hiden.

 

[Guest]

tr
For row=1 to lastro
if condition then cells(row,1).entirerow.hid
Next

 

[Supriya]

Let me elaborate.
I have 2 sheets "call details" and "Reports"

The columns of Reports make cell reference to cells in Call Details
which contains formulas. So, 0 is shown if no calculations ar
done(condition). I want the rows in reports to be shown only if it ha
values(based on cell reference). Until then it should be hidden

 

[Guest]

So for example, you have a formula in column A, which gives either TRUE or FALSE, and you have 20 rows of data. You could call procedure from worksheet_activate or data_change

sub ShowOnlyTrueRows
for row=1 to 20
if cells(row,1)=true then
cells(row,1).entirerow.hide
else
cells(row,1).entirerow.unhide
end if
next
end sub

 

[Supriya]

How to call the Procedure from worksheet_activate?

Where to write the code