I need to create a shortcut to type in that will bring up the formula =subtotal(9,x:x+3), that also allows me to change the range. Define Name works but doesn't allow me to change the range of the things I am doing. For reference the reason I am needing this is work colleagues are getting confused with Subtotal(9, when they are so used to seeing sum( Thanks Leigh
Solved by V. H. in 24 mins