in row A i have dates (multiple, but ascending)
i need to find the row that first contains a date and the last row that
contains that same date

thanks in advance

Assuming your data is in A1:A16, then for the first use:
=MATCH(A1,$A$1:$A$16,0)
and last
=MATCH(A1,$A$1:$A$16,1)

Note that this returns the position with respect to the array selected.
Please adjust the value by adding the rows to each formula if you are not
starting at top. For e.g. your start from A2, then add 1 to both formulae.

Mangesh



"choice" wrote in message
...
in row A i have dates (multiple, but ascending)
i need to find the row that first contains a date and the last row that
contains that same date

thanks in advance

Hi Choice,

Try this macro if this works for you.

1. Select all data or range you are interested to find and run the macro
below.

Sub SelectStringCells()
Dim rCell As Range
Dim IString As String
Dim rSelected As Range

IString = "1/12/2001"

Set rSelected = Nothing
For Each rCell In Selection
If rCell.Value = IString Then
If rSelected Is Nothing Then
Set rSelected = rCell
Else
Set rSelected = Union(rSelected, rCell)
End If
End If
Next
If rSelected Is Nothing Then
MsgBox "No cells value match"
Else
rSelected.Select
MsgBox "Found the Dates"
End If
Set rCell = Nothing
Set rSelected = Nothing
End Sub

Hope this helps.

"choice" wrote:

in row A i have dates (multiple, but ascending)
i need to find the row that first contains a date and the last row that
contains that same date

thanks in advance