VBA/Excel

Resolved · Low Priority · Version 2003

Fri 22 Jan 2010, 14:45 Delegate 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:21 Trainer 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