View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Soo Cheon Jheong Soo Cheon Jheong is offline
external usenet poster
 
Posts: 14
Default Goto Next VISIBLE cell below

Try this:

Dim rng As Range
Dim i As Long
For Each rng In Range(ActiveCell, Cells(Rows.Count,
ActiveCell.Column)).SpecialCells(Type:=12, Value:=23)
If i 0 Then
rng.Select
Exit For
End If
i = i + 1
Next

--
Soo Cheon Jheong
http://excel.hompy.com