macros

[Ashby]

i am trying to make a macro that will take a number in V1
then apply a formula and put the answer in V2. then when
it is hit again it will take the number in V2 and apply a
formula and put the answer in V3. and so on(v3 to V4.....)
Thank you in advanced,

 

[Don Guillett]

This might work if you already have a number in a1. If not, execute fixit
macro
Place both in the worksheet module

Sub fixit()
Application.EnableEvents = True
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 1 Then
x = Cells(65536, 1).End(xlUp).Row - 1
Target.Offset(x + 1) = Target.Offset(x) * [a1]
End If
Application.EnableEvents = True
End Sub