Thread: Cell addresses
View Single Post
  #2 (permalink)  
Old July 31st, 2009, 01:55 AM
Shasur Shasur is offline
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

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