View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lesley1000 lesley1000 is offline
external usenet poster
 
Posts: 1
Default Summing an unkown number of columns

I put into Excel weekly figures (there change each week and time I put them
in). I want to do a sum of the row at the end to generate a total. Doing this
in excel is fine, but I want the code to sum from column D (this is fixed
each week) until the last column, which will be different each time I run the
macro. I've tried naming the cells, but VBA doesn't do it correctly, it will
do a fixed number of columns. Any suggestions?