catgreen
10-02-2012, 05:48 AM
Hello all,
I have an Excel 2007 table which has 1500 rows and 60 columns of data. I use autofilter to filter out some information. For example I have filtered row 5, 12, 12 and 18. I select some rows (row 5 and 12)
I need a macro to find out the row numbers of these selected rows.
Thanks in advance.
catgreen
I have an Excel 2007 table which has 1500 rows and 60 columns of data. I use autofilter to filter out some information. For example I have filtered row 5, 12, 12 and 18. I select some rows (row 5 and 12)
I need a macro to find out the row numbers of these selected rows.
Thanks in advance.
catgreen