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?
Thanks
Mike
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...
Selection.SpecialCells(xlCellTypeVisible).Select
...prior to your For Each statement.
