I am trying to insert a simple subtotal formula in a macro, using variants as the bottom of the range will change.
What I can't work out is the placement of the ""s and the &s
I've already defined strTop as the top cell in the range and strBottom as the bottom cell (cell above the subtotal).
Currently I have -
I've tried this and a dozen+ variations but Excel won't accept them!!
Any help - and general advice on how to use the ""s and &s... in these situations - greatly appreciated.
Also, is there a simpler way to do this? I need to copy this formula across the next 53 columns, and the only way I can think of is to use the above and then redefine StrTop and StrBottom each time for the next 53 columns. :?
Many, many thanks for any help.