H
HammerJoe
Hi,
Column D starting at row 3 contains Dates.
This is a dynamic table that grows everyday.
Because there will be thousand of rows I need to do some calculations
on only some of those rows.
In other words I have an initial date and a finish date. (format
2008/01/01)
First I am using "TotalBigListCount =
SheetSource.UsedRange.Rows.Count" to give the the last row containing
data
Next I have:
With SheetSource.Range("D" & StartRow, "D" & TotalBigListCount)
Set c = .Find(DateFromString, LookIn:=xlValues)
RowDateCount = c.Row
End With
This gives me the first row that will match the Initial Date
(DateFromString). Pretty simple.
Now I would like to do the same to find the last row in the table that
matches the DateToString (finish date).
Is there an easy way to get it or the only option is to use a do while
loop to go thru all the rows until it finds that last match?
Thanks
Column D starting at row 3 contains Dates.
This is a dynamic table that grows everyday.
Because there will be thousand of rows I need to do some calculations
on only some of those rows.
In other words I have an initial date and a finish date. (format
2008/01/01)
First I am using "TotalBigListCount =
SheetSource.UsedRange.Rows.Count" to give the the last row containing
data
Next I have:
With SheetSource.Range("D" & StartRow, "D" & TotalBigListCount)
Set c = .Find(DateFromString, LookIn:=xlValues)
RowDateCount = c.Row
End With
This gives me the first row that will match the Initial Date
(DateFromString). Pretty simple.
Now I would like to do the same to find the last row in the table that
matches the DateToString (finish date).
Is there an easy way to get it or the only option is to use a do while
loop to go thru all the rows until it finds that last match?
Thanks