I'm looking for something very similar but I want to be able to hit
macro button when the active cell is directly above the data and i
will insert the subtotal formula. Any ideas

--
Message posted from http://www.ExcelForum.com