Thread
:
Goto Next VISIBLE cell below
View Single Post
#
5
Posted to microsoft.public.excel.programming
Soo Cheon Jheong
external usenet poster
Posts: 14
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
Reply With Quote
Soo Cheon Jheong
View Public Profile
Find all posts by Soo Cheon Jheong