Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |