Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2002, WinXP
The code below is a simplification of my code to demonstrate my problem. I have a, b, c, d, e in A1:A5. Rows 3:5 are hidden rows I want to search the range A1:A5, in VBA, to find the row number of the "c" entry. This code will not work because Row 3, the "c" row, is hidden. My intent is to find the row, unhide it, and work with it. Question: Is there a way to find the row number of the "c" entry, short of unhiding the whole Rng first? One way is to loop through Rng and look for "c". Is there a better way? Thanks for your help. Otto Sub FindHidden() Dim Rng As Range Dim c As Long Set Rng = [A1:A5] c = Rng.Find(What:="c", _ After:=[A1], LookIn:=xlValues, LookAt:=xlWhole).Row MsgBox c End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find last row with hidden rows | Excel Discussion (Misc queries) | |||
how to find out if a row is hidden | Excel Worksheet Functions | |||
DATEDIF() The hidden function - You may find it useful. | Excel Worksheet Functions | |||
How to find hidden text | Excel Worksheet Functions | |||
Find Last Row Hidden | Excel Programming |