VBA Code to find the Row Number of the last repeated row of aparticular date field
On Wednesday, August 31, 2016 at 10:09:28 AM UTC+5:30, shriil wrote:
I have this Table where the first field is a Date Field where the dates are repeated.
Column A
1 14-Aug-2016
2 14-Aug-2016
3 15-Aug-2016
4 15-Aug-2016
5 15-Aug-2016
6 17-Aug-2016
7 17-Aug-2016
8 17-Aug-2016
9 17-Aug-2016
10 17-Aug-2016
11 17-Aug-2016
12 18-Aug-2016
13 19-Aug-2016
14 19-Aug-2016
I need to write a code to get the Row Number of the last repeated Row of a particular date, say for 14-Aug-2016 it would be Row No. 2, for 17-Aug-2016, it is Row No.9...
Help please
San
Thanks. Will try it out.
San
|