Thread: Cell addresses
View Single Post
  #1 (permalink)  
Old July 31st, 2009, 12:09 AM
SMI// SMI// is offline
Authorized User
Points: 125, Level: 2
Points: 125, Level: 2 Points: 125, Level: 2 Points: 125, Level: 2
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2009
Posts: 23
Thanks: 1
Thanked 0 Times in 0 Posts
Default Cell addresses

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.
Reply With Quote