View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Kevin McCartney[_2_] Kevin McCartney[_2_] is offline
external usenet poster
 
Posts: 32
Default How To: VBA Cells.Find(..... also look in hidden columns?

To banana it works
Cheers buddy
regards
KM
-----Original Message-----
If you replace xlValues with xlFormulas, it works for me

with a hidden
column.

--
Regards,
Tom Ogilvy

"Kevin McCartney"

wrote in message
...
Hi,
I'm try to find a value in a specific column. The

column
itself is hidden.

I use the command, rgeUniqueID.Cells.Find
(What:=strFindUniqueID, LookIn:=xlValues,
SearchOrder:=xlRows, MatchCase:=False)

The code works fine when the column is not hidden. The
point is that I don't want to hide and show the column
each time a need to search for a Unique ID.

Thanks for your help
regards
KM



.