Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find value in hiden row
Is there any way to get the code below to find the value NoXXX which is in a
hidden column? Sub NextRow() ' ' Macro4 Macro ' ' Cells.Find(What:="NoXXX", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find value in hiden row
You can't activate a hidden cell. Try this
set c = Cells.Find(What:="NoXXX", After:=ActiveCell, _ LookIn:=xlValues, LookAt:=xlPart) "Patrick C. Simonds" wrote: Is there any way to get the code below to find the value NoXXX which is in a hidden column? Sub NextRow() ' ' Macro4 Macro ' ' Cells.Find(What:="NoXXX", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find value in hiden row
First unhide the columns, second, do the search, third, hide the colums
again. Sub NextRow() ' ' Macro4 Macro ' ' ActiveSheet.Columns.Hidden = False Cells.Find(What:="NoXXX", After:=ActiveCell, _ LookIn:=xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate 'Put code to re-hide columns here End Sub "Patrick C. Simonds" wrote in message ... Is there any way to get the code below to find the value NoXXX which is in a hidden column? Sub NextRow() ' ' Macro4 Macro ' ' Cells.Find(What:="NoXXX", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I find A column when it's hiden? | Excel Worksheet Functions | |||
Why can't I unhide a hiden row | Excel Discussion (Misc queries) | |||
Is column hiden? | Excel Programming | |||
Is column hiden? | Excel Programming | |||
hiden sheet | Excel Programming |