Variable in a formula

  • Thread starter Thread starter GM
  • Start date Start date
G

GM

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
 
and the formula is ....?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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
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
Click to expand...

.
Click to expand...
 
Hi
try
ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable &
"]C2,Sheet1!R[9]C1)"


--
Regards
Frank Kabel
Frankfurt, Germany
GM said:
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
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
Click to expand...

.
Click to expand...
Click to expand...
 
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 said:
Hi
try
ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable &
"]C2,Sheet1!R[9]C1)"


--
Regards
Frank Kabel
Frankfurt, Germany
GM said:
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
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

.
Click to expand...
Click to expand...
Click to expand...
 
what about the other on said:
ActiveCell.FormulaR1C1 = "=MID(R2C5,Sheet1!R[" & your_variable &
"]C2,Sheet1!R[[" & your_variable & "]]C1)"
Click to expand...

$#&"! missed that one :-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Variable to someone 5
Inability to add quotation mark around a variable by concatenation in VBA 4
loop through class module 2
Inserting Formula moving down each row 2
refering to a variable in a cell.formula 7
Use Value of Dynamically Created Variable 5
Converting ISBNs: 13 to 10 15
Need to flag the lead ID of any contiguous ID's from a sorted list of ID's. 5

Back
Top