| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using .Find with Hidden Columns
Is there a way to have the .find method look in hidden columns of data? Or
is my only solution to unhide all columns, perform the find, then rehide the appropriate columns (all in VBA). |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using .Find with Hidden Columns
Tell the find function to look in xlFormulas and the hidden columns should
be searched. rng = cells.find(what:="ABCD", Lookin:=xlFormulas, Lookat:=xlWhole) as an example -- Regards, Tom Ogilvy "D" wrote in message ... Is there a way to have the .find method look in hidden columns of data? Or is my only solution to unhide all columns, perform the find, then rehide the appropriate columns (all in VBA). |
| 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) | |||
| Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
| Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
| Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
| How To: VBA Cells.Find(..... also look in hidden columns? | Excel Programming | |||
Hybrid Mode
