| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I denote values stored in columns in my macro?
I need to write a macro that will calculate a value based on one of 2
formulas. The formula is dependent on the value in another cell. How do I do this |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I denote values stored in columns in my macro?
if range("A1").Value 10 then
code to use formula 1 else code to use formula 2 End if -- Regards, Tom Ogilvy "Greg" wrote in message ... I need to write a macro that will calculate a value based on one of 2 formulas. The formula is dependent on the value in another cell. How do I do this |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I denote values stored in columns in my macro?
I need to multiply:
C7*I7*.25 How do I code the values in C7 and I7 into the formula for K7 (the column I'm writing a macro for? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I denote values stored in columns in my macro?
Range("K7").Formula = "=C7*I7*.25"
if you want to do the calculation in vba v = Range("C7").Value * Range("I7").Value * 0.25 Range("K7").Value = v -- Regards, Tom Ogilvy "Greg" wrote in message ... I need to multiply: C7*I7*.25 How do I code the values in C7 and I7 into the formula for K7 (the column I'm writing a macro for? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to hide columns with zero values? | Excel Discussion (Misc queries) | |||
| Is there an easy way to denote significance on charts | Charts and Charting in Excel | |||
| Need to combine dates stored in seperate columns | Excel Discussion (Misc queries) | |||
| How to use values stored in a combo box control? | Excel Discussion (Misc queries) | |||
| vba clearing out values stored in array | Excel Programming | |||
Linear Mode
