View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Przemek Wrzesinski Przemek Wrzesinski is offline
external usenet poster
 
Posts: 4
Default get subtotals results as a variable

Hi, every month I've got spreadsheet with payments (thousands of rows).
Usually I'm using subtotals to get sums grouped by currency. I know how to
write code in VBA for subtotals, but how can I get the results for
subtotals eg. as a variable? Number of payments is different every month,
so I can't used hard references to cells.
Or is it possible to name (named range) cells with subtotals results?

--
Przemek
Now playing: nothing