| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert variable cell in the formula
Hi,
I try to insert a formula to multiply two rows, like A1*C1, A2*C2....., how can I do that by using a FOR loop in the marco? Thanks. Gian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert variable cell in the formula
You don't need to loop
Assume you want the formula in column D set rng = Range(Cells(1,1),Cells(rows.count,1).End(xlup)) rng.offset(0,3).Formula = "=A1*C1" -- Regards, Tom Ogilvy "Gian" wrote in message ... Hi, I try to insert a formula to multiply two rows, like A1*C1, A2*C2....., how can I do that by using a FOR loop in the marco? Thanks. Gian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert variable cell in the formula
Thanks Tom.
I just curious, it's possible to put the variable in the formula, like "=chr(65)&1 * chr(67)&1" "Tom Ogilvy" wrote: You don't need to loop Assume you want the formula in column D set rng = Range(Cells(1,1),Cells(rows.count,1).End(xlup)) rng.offset(0,3).Formula = "=A1*C1" -- Regards, Tom Ogilvy "Gian" wrote in message ... Hi, I try to insert a formula to multiply two rows, like A1*C1, A2*C2....., how can I do that by using a FOR loop in the marco? Thanks. Gian |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert variable cell in the formula
"=" & chr(65) & "1" & "*" & chr(67) & "1"
testing from the immediate window: ? "=" & chr(65) & "1" & "*" & chr(67) & "1" =A1*C1 But I am not sure that is what you are trying to achieve. -- Regards, Tom Ogilvy "Gian" wrote in message ... Thanks Tom. I just curious, it's possible to put the variable in the formula, like "=chr(65)&1 * chr(67)&1" "Tom Ogilvy" wrote: You don't need to loop Assume you want the formula in column D set rng = Range(Cells(1,1),Cells(rows.count,1).End(xlup)) rng.offset(0,3).Formula = "=A1*C1" -- Regards, Tom Ogilvy "Gian" wrote in message ... Hi, I try to insert a formula to multiply two rows, like A1*C1, A2*C2....., how can I do that by using a FOR loop in the marco? Thanks. Gian |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert variable cell in the formula
Hi Tom, This is exactly what I want. Appreciate your help. BTW, what the "End(xlup)" for? Thanks "Tom Ogilvy" wrote: "=" & chr(65) & "1" & "*" & chr(67) & "1" testing from the immediate window: ? "=" & chr(65) & "1" & "*" & chr(67) & "1" =A1*C1 But I am not sure that is what you are trying to achieve. -- Regards, Tom Ogilvy "Gian" wrote in message ... Thanks Tom. I just curious, it's possible to put the variable in the formula, like "=chr(65)&1 * chr(67)&1" "Tom Ogilvy" wrote: You don't need to loop Assume you want the formula in column D set rng = Range(Cells(1,1),Cells(rows.count,1).End(xlup)) rng.offset(0,3).Formula = "=A1*C1" -- Regards, Tom Ogilvy "Gian" wrote in message ... Hi, I try to insert a formula to multiply two rows, like A1*C1, A2*C2....., how can I do that by using a FOR loop in the marco? Thanks. Gian |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert variable cell in the formula
go well below you data and hit the End Key, then the Up Arrow key. It takes
you to the last cell containing data in that column. It is the same in code. So I am finding the extent of your data in column A. -- Regards, Tom Ogilvy "Gian" wrote in message ... Hi Tom, This is exactly what I want. Appreciate your help. BTW, what the "End(xlup)" for? Thanks "Tom Ogilvy" wrote: "=" & chr(65) & "1" & "*" & chr(67) & "1" testing from the immediate window: ? "=" & chr(65) & "1" & "*" & chr(67) & "1" =A1*C1 But I am not sure that is what you are trying to achieve. -- Regards, Tom Ogilvy "Gian" wrote in message ... Thanks Tom. I just curious, it's possible to put the variable in the formula, like "=chr(65)&1 * chr(67)&1" "Tom Ogilvy" wrote: You don't need to loop Assume you want the formula in column D set rng = Range(Cells(1,1),Cells(rows.count,1).End(xlup)) rng.offset(0,3).Formula = "=A1*C1" -- Regards, Tom Ogilvy "Gian" wrote in message ... Hi, I try to insert a formula to multiply two rows, like A1*C1, A2*C2....., how can I do that by using a FOR loop in the marco? Thanks. Gian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert contents of variable cell address | Excel Discussion (Misc queries) | |||
| how do I insert a variable amount of blank spaces in a formula? | Excel Worksheet Functions | |||
| insert a variable into a formula | Excel Discussion (Misc queries) | |||
| Can one insert a variable/cell ref. in the heading | Excel Discussion (Misc queries) | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
Linear Mode
