If I have a formula in a cell how can I keep the current formula but and add to it?
Example:
Sub DoesStuff
Range("A1").ForumlaR1C1 = "= R[1]C + R[5]C"
{other stuff happens}
Range("A1").ForumlaR1C1 = Range("A1").ForumlaR1C1 & "+ R[9]C"
End Sub
This fails. What can I do to make it work?
Bookmarks