Fri 22 Jan 2010, 14:45Delegate Justin said...
Justin has attended:
Excel VBA Intro Intermediate course
VBA/Excel
If in the VB code you have told it to add cell A1 with cell A2 and return the answer in cell A3, can you get the code to return the answer as well as the formula used.
eg
So if A1 = 2 and A2 = 3, cell A3 returns 5, as wells as showing when you click in cell A3 that the calculation is =A1+A2
Wed 27 Jan 2010, 15:21Trainer Simon said...
RE: VBA/Excel
Hi Justin,
Thank you for your question and sorry about the delay in responding.
After speaking to my colleague I would suggest you use the FormulaR1C1 property of the activecell object and then create a loop to repeat the procedure for the other totals.
During the course I believe you were starting to think along these lines.
I hope this helps.
Regards
Simon
