Autofilter Get selected cells value

J

Juvigy

Joined
Sep 2, 2010
Messages
2
Reaction score
0
A have a sheet where i have applied filters in the first row. When i select several cells with the mause and then execute a macro where it says :

Code: 
text =selection.value

Text contains more cells values then the visible cells that are selected. If i try something like

Code: 
text = selection.SpecialCells(12).value

then
Code: 
text
holds only the first cell value.

How can i get the selected cells value when a filter has been applied?
 
Back
Top