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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to add comments to selected cells within a selected range 30
If/Elseif AutoFilter Macro 4
Use Selection.SpecialCells for cells with a particular value? 6
help with a piece of code 5
calculations on autofilter selected cells 0
VBA: determine if value is invisible in autofilter 2
How to create object to follow selected cells in vba 2
Formatting issue 2

Top