| 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 |
| 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 | |||
![Kevin McCartney[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
