Greetings

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.

Objective
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.

Thanks.

Hi

You can use the visible cells (specialcells property) to get the group of cells

I have tried the same to get the first cell (http://vbadud.blogspot.com/2008/08/r...-of-excel.html) of the Filtered Set. However, you can tweak it to get the range

Please let me know if you need any help on this

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)