MrExcel Publishing
Your One Stop for Excel Tips & Solutions

selecting values from an array limited with autofilter

Posted by Mike Merkel on July 11, 2001 8:13 AM

Does anyone know how i select the values (one by one) from an array that was limited with autofilter. I tried to filter the array first and then I tried a for each row in selection statement. that didn't do the trick. any ideas?

Posted by Mark W. on July 11, 2001 8:29 AM

This sounds like a VBA question which isn't my
"strong suit", but did you consider modifying
your selection by using...


...prior to your For Each statement.