Adding individual cell ref - instead of summation

  • Thread starter Thread starter al007
  • Start date Start date
A

al007

Does anybody you has a macro which cnan change this formulacontaining
sum =SUM('1999'!A1:A2,'2000'!A1,'2001amended'!A1:B1)

into: = :'1999'!A1+'1999'!A2+'2000'!A1+2001amended'!A1+2001amended'!B1

reason being I like to use the summation icon instead of the + sign

Thanks
 
1. There are two apostrophes missing in the second expression.
scooper
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming non-contigent cells with vba 5
Summation of the Cells 1
Need macro code to pick data according to year selected 1
accessing value of a cell having formula 1
Re. Conditional formating of adjacent cells but down a column 0
Subtract cell formula from existing cell formula 2
Run Macro Upon Entering Data into Cell/s 3
some more explanation 11

Back
Top