Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using .find to find a value in a hidden column
- Thread starter Cage
- Start date
Something like this should work - the WITH means that the column is IMPLICITLY used rather than actually being selected:
fWhat = "DatatoFind"
With ActiveSheet.Columns("D"
'where D is hidden
Set fCell = .Find(fWhat,lookin:=xlvalues,lookat:=xlwhole)
MsgBox fCell.Address
End With
HTH Rgds
~Geoff~
fWhat = "DatatoFind"
With ActiveSheet.Columns("D"
'where D is hiddenSet fCell = .Find(fWhat,lookin:=xlvalues,lookat:=xlwhole)
MsgBox fCell.Address
End With
HTH Rgds
~Geoff~
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question