| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding value in a hidden sheet
My code seems to fail because I am searching a value in a
hidden sheet. Any idea? I get the following message (runtime error 1004, activate method out of range class failed) Dim Cell As Range Set Cell = Range("List").Find(What:=Range("nametofind")) Cell.Activate PS: list and nametofind are defined names |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding min date value with hidden zeros with vlookup | Excel Worksheet Functions | |||
| Finding all cells that are locked/hidden | Excel Discussion (Misc queries) | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming | |||
| Problem pasting a row from a hidden sheet to the first free row on another visible sheet | Excel Programming | |||
Threaded Mode
