Returning a value, not a formula

Hey all, I need a little help with something pretty basic. I have a macro that performs a simple calculation. How do I return only the result, the integer information, to the cell without the formula tracking along with it?

ActiveCell.FormulaR1C1 = "=R[-1]C+1"

Thanks for any help on this! :)

I've been trying something like this...

Dim z As Integer

Set z = ActiveCell.FormulaR1C1 = "=R[-1]C+1"
ActiveCell.Value = z

But calling out a formula in a variable definition seems to be a problem...

Thanks again....

Dim z As Integer

z = Activecell.offset(-1,0).value + 1
ActiveCell.Value = zShould do the trick, or just ActiveCell.Value = Activecell.offset(-1,0).value + 1

Perfect! Thanks! :D