I am applying autofilters to two different tables in different spreadsheets via macro.
Later for the VISIBLE Range after autofilter, I need to perform some calculations between two tables.
How can I set the Range of visible records ?
for example to get first and last row of visible Records ? and to perform calculations only on visible rows !