I wrote some basic code to process data from a simple spreadsheet of 3 columns. So far, no problems.
The user incorporated an autofiler.
How do I make the code recognize only the auto filtered data as opposed to the whole sheet?
For example -- TOTRows = SheetA.UsedRange.Rows.Count still returns the total number of rows and not the ones displayed.
thanks in advance !
Jorge
(green programmer)
The user incorporated an autofiler.
How do I make the code recognize only the auto filtered data as opposed to the whole sheet?
For example -- TOTRows = SheetA.UsedRange.Rows.Count still returns the total number of rows and not the ones displayed.
thanks in advance !
Jorge
(green programmer)