S
Supriya
How do I Autohide the rows when there is no entry, & show them when an
entry is made?
entry is made?
P
Peter Russell
That's a clever concept - entering data into hidden rowsSupriya said:
-)Peter
G
Guest
cells(row,column)="data" wouldn't have a problem if the row was hiden. 
G
Guest
tr
For row=1 to lastro
if condition then cells(row,1).entirerow.hid
Next
For row=1 to lastro
if condition then cells(row,1).entirerow.hid
Next
S
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
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
G
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
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
S
Supriya
How to call the Procedure from worksheet_activate?
Where to write the code
Where to write the code