| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in a formula
In this formula I would like [9] to become a variable that
will loop/next from 10 to 63. There are some other piecies to this code, I just need to know how to make that 9 x. TYIA GM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in a formula
Hi
which formula do you mean :-) -- Regards Frank Kabel Frankfurt, Germany "GM" schrieb im Newsbeitrag ... In this formula I would like [9] to become a variable that will loop/next from 10 to 63. There are some other piecies to this code, I just need to know how to make that 9 x. TYIA GM |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in a formula
and the formula is ....?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "GM" wrote in message ... In this formula I would like [9] to become a variable that will loop/next from 10 to 63. There are some other piecies to this code, I just need to know how to make that 9 x. TYIA GM |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in a formula
Boy am I stupid this formula
ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[9] C2,Sheet1!R[9]C1)" -----Original Message----- Hi which formula do you mean :-) -- Regards Frank Kabel Frankfurt, Germany "GM" schrieb im Newsbeitrag ... In this formula I would like [9] to become a variable that will loop/next from 10 to 63. There are some other piecies to this code, I just need to know how to make that 9 x. TYIA GM . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in a formula
Hi
try ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable & "]C2,Sheet1!R[9]C1)" -- Regards Frank Kabel Frankfurt, Germany "GM" schrieb im Newsbeitrag ... Boy am I stupid this formula ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[9] C2,Sheet1!R[9]C1)" -----Original Message----- Hi which formula do you mean :-) -- Regards Frank Kabel Frankfurt, Germany "GM" schrieb im Newsbeitrag ... In this formula I would like [9] to become a variable that will loop/next from 10 to 63. There are some other piecies to this code, I just need to know how to make that 9 x. TYIA GM . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in a formula
what about the other on<vbg
ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable & "]C2,Sheet1!R[[" & your_variable & "]]C1)" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable & "]C2,Sheet1!R[9]C1)" -- Regards Frank Kabel Frankfurt, Germany "GM" schrieb im Newsbeitrag ... Boy am I stupid this formula ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[9] C2,Sheet1!R[9]C1)" -----Original Message----- Hi which formula do you mean :-) -- Regards Frank Kabel Frankfurt, Germany "GM" schrieb im Newsbeitrag ... In this formula I would like [9] to become a variable that will loop/next from 10 to 63. There are some other piecies to this code, I just need to know how to make that 9 x. TYIA GM . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in a formula
what about the other on<vbg
ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable & "]C2,Sheet1!R[[" & your_variable & "]]C1)" $#&"! missed that one :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable VBA Max Formula | Excel Discussion (Misc queries) | |||
| DDE formula with variable | Excel Worksheet Functions | |||
| Variable within a formula | Excel Worksheet Functions | |||
| Using a second variable within a formula... | Excel Discussion (Misc queries) | |||
| Variable to formula. | Excel Programming | |||
![GM[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
