Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
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 -- Don Guillett SalesAid Software Granite Shoals, TX "Ashby" wrote in message ... 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |