Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Product calculation macro
I need my macro to do a calculation in cell h3. The calculation logic should
be: Multiply value in cell G3 by value in cell H1. This value should then show up in cell H3. Then I need it to do the same thing for the next row (multiply value in cell G4 by value in cell H1 and place answer in cell H4. I need to this to fill down for all used rows. Thanks in advance. Mike |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Product calculation macro
iLastRow = Cells(Rows.Count, "G").End(xlUp).Row For i = 3 To iLatRow Cells(i,"H).Value = Cells(i,"G").Value * Range("H1").Value Next i -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "MikeD1224" wrote in message ... I need my macro to do a calculation in cell h3. The calculation logic should be: Multiply value in cell G3 by value in cell H1. This value should then show up in cell H3. Then I need it to do the same thing for the next row (multiply value in cell G4 by value in cell H1 and place answer in cell H4. I need to this to fill down for all used rows. Thanks in advance. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to go to cell based upon a calculation | Excel Discussion (Misc queries) | |||
MACRO TO SET THE AUTOMATIC CALCULATION | Excel Discussion (Misc queries) | |||
how to raise the Macro security level in a product I can't execute | Excel Discussion (Misc queries) | |||
product calculation in excel | Excel Worksheet Functions | |||
How to automatic calculation and macro execution between 3 workbooks? | Excel Worksheet Functions |