IF statement not working as expected?

Hi All,

I have two worksheets named "Data" and "Product". I want to use the following macro to sort the records depending which sheet is active. If I am in the "Data" sheet, it does the sort in the "Product" sheet? I was expecting it to ignore the second IF statement when I am in the "Data" sheet? Please help.

Please Login or Register  to view this content.

Thank You

You are testing to see if the sheets are visible, which is not the same as being active.
Both sheets ARE visible, (ie. not Hidden), so both 'IF' statements will run.
Try testing to see which sheet the activesheet is instead.
Change:

Please Login or Register  to view this content.

To be:

Please Login or Register  to view this content.

Obviously you need to change the other IF statement as well

It would be even easier if you named the range on each sheet 'Data' - then you could just sort the Data range on the active sheet.