Help AutoFilter
:) 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 -- xcelio ----------------------------------------------------------------------- xcelion's Profile: http://www.excelforum.com/member.php...fo&userid=1628 View this thread: http://www.excelforum.com/showthread.php?threadid=27688 |
Help AutoFilter
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. -- Regards, Tom Ogilvy "xcelion" wrote in message ... :) Hi All, I am new in vba coding.I have a problem.I used Autofilter to get some rows based on criteria.After setting the autofilter on, i used current region to copy the records when iam copying the current region it's working fine.But i want it to return records as an array,Then what happens is array is returned with all the records that is unfiltered records.Even if iam taking CurrentRegion.Rows.count iam getting the total number not the filtered number .What should i do ? Can any body hep me on this? Thanks in advance xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=276880 |
All times are GMT +1. The time now is 04:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com