Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To: VBA Cells.Find(..... also look in hidden columns?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To: VBA Cells.Find(..... also look in hidden columns?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To: VBA Cells.Find(..... also look in hidden columns?
Hmmm, it doesn't see to like the xlValues parameter.
Trying to replicate the approach: rngUniqueID.Cells.SpecialCells(xlCellTypeConstants ). _ Find(What:=strFindUniqueID, LookIn:=xlFormulas, _ SearchOrder:=xlRows, MatchCase:=False) seems to work for hidden columns. Specialcells has a disadvantage in that it can't be used in a protected sheet. Reprotecting the sheet with userinterfaceonly will work around that limitation if applicable. "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Hidden rows/columns expand when referencing cells? | Excel Worksheet Functions | |||
drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
how do i copy formula down columns avoiding hidden cells | Excel Discussion (Misc queries) | |||
PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns | Excel Worksheet Functions |