Autofilter Get selected cells value

Juvigy · Juvigy's Computer Specifications

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?

Juvigy · Juvigy's Computer Specifications

Is it possible or not?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
function to reference value selected with autofilter	cm	Microsoft Excel Worksheet Functions	2	16th Sep 2009 04:56 AM
What was selected in autofilter	=?Utf-8?B?SGVucmljaA==?=	Microsoft Excel Programming	3	10th Aug 2006 11:17 AM
calculations on autofilter selected cells	jannie	Microsoft Excel Programming	0	8th Aug 2006 11:50 AM
Autofilter - =string in selected cell	al007	Microsoft Excel Programming	3	1st Dec 2005 04:37 PM
Find out what is selected for AutoFilter	=?Utf-8?B?RGFu?=	Microsoft Excel Programming	3	20th Jul 2005 05:31 PM