Here is an example of my data with A,B,C etc as columns and left most values as row numbers:
A B C
212 Mike Driver 12-Jun-04
227 Nicholas Driver 19-Nov-08
436 David Driver 14-Apr-05
This is an extract of a data of 12000 or more rows few more columns. For example purpose only 3 columns have been taken. Suppose I used an AutoFilter with driver as the criteria and above is a filtered list of exployees with this designation.
I want to know cell addresses of each of the above cells even though filter has been applied to the sheet. Is there a way?
I tried to do this using range("a1").End(xlDown).Address but that only takes me to row number 436 which is the last row in the filtered data. And then if I use Activecell.End(xlup).Address, it takes me to cell A1 instead of cell A227.
I hope it all makes sense what I am trying to get here.