Cell A3 has the sum function in it.
When writing excel VBA code you can choose what do you need to return the value or the function inside the cell.
Use Value to see a result of 30
Use Formula to see the text in the cell
Use Excels VBA immediate window to show you what it will return as your answer.
Ctrl G will bring up the immediate window.
for more tips visit http://www.azsolutions.com.au