Help AutoFilter

[xcelion]

Hi All,

I am new in vba coding.I have a problem.I used Autofilter to get som
rows based on criteria.After setting the autofilter on, i used curren
region to copy the records
when iam copying the current region it's working fine.But i want it t
return records as an array,Then what happens is array is returne
with all the records that is unfiltered records.Even if iam takin
CurrentRegion.Rows.count iam getting the total number not the filtere
number .What should i do ?
Can any body hep me on this?

Thanks in advance
xcelio

 

[Tom Ogilvy]

You have to load the array one cell at a time, either testing if the row is
hidden, or using SpecialCells to only work with the visible rows.