If it isn't throwing any errors then it should be doing something.

Try manually unhiding all rows on your worksheet and then re-running the macro to see if it does anything.

If it still doesn't work, would it be possible to attach your spreadsheet?