My excel sheet has a list of names with info corresponding to the name
in the same row. I am constantly adding and deleting names and hiding
and unhiding rows. I decided to write a code that will search through
the list of names. Find the first "available" row and make it
visible. The part I am having trouble with right now is hiding and
unhiding. Here is my code:

Sub Findnshow
with worksheets(2).range("a4:a15")
'look for blank cell
set c = .find("", lookin:=xlvalues)
if not c is nothing then
firstaddress = c.address
select blank cell
c.select
end if
end with
hide entire row
selection.entirerow.hidden=true
end sub

If i try to unhide the row it does the search but does noot look at
the hidden cell. It skips to the next available cell and since it is
not hidden it does nothing. How can I unhide it?

Try looking in xlformulas instead of xlvalues.



stewdizzle wrote:

My excel sheet has a list of names with info corresponding to the name
in the same row. I am constantly adding and deleting names and hiding
and unhiding rows. I decided to write a code that will search through
the list of names. Find the first "available" row and make it
visible. The part I am having trouble with right now is hiding and
unhiding. Here is my code:

Sub Findnshow
with worksheets(2).range("a4:a15")
'look for blank cell
set c = .find("", lookin:=xlvalues)
if not c is nothing then
firstaddress = c.address
select blank cell
c.select
end if
end with
hide entire row
selection.entirerow.hidden=true
end sub

If i try to unhide the row it does the search but does noot look at
the hidden cell. It skips to the next available cell and since it is
not hidden it does nothing. How can I unhide it?

--

Dave Peterson