Elleira2, I just posted on how to create a AutoSUBTOTAL macro, and you can name it whatever you want. I based it off an earlier post which showed how to replicate the Alt + = function with a macro, so either should work for you. Good luck!

http://www.excelforum.com/excel-prog...-in-excel.html