Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set a variable in Excel and loop
Dim varCount As String VarCount = 5 Dim I As Integer For I = 1 To 10 Step 1 Range("B1").Select ActiveCell.FormulaR1C1 = "=Sheet1!R[VarCount]C" Range("C1").Select ActiveCell.FormulaR1C1 = "=Sheet1!R[VarCOunt]C" VarCount = Varcount + 1 Range("D1").Select Next I End Sub Well I hope that for the pro's here this is clear and know what th answer is, well just to explain, in sheet Sheet1 starting on collum B down there are names which i want to "put" in another sheet at cell B and then print this page, then the B2 at sheet1, then B3, so to make long story short, the vat Varcount must be a number value, if i put at where VarCount is the macro will work but print the value o Sheet1!R[1] ten times :) So the outcome must be that it's Sheet1!R[1], Sheet1!R[2], Sheet1!R[3 ect. Hope somebody here has an answer. Thanks -- frankep ----------------------------------------------------------------------- frankeps's Profile: http://www.excelforum.com/member.php...fo&userid=1571 View this thread: http://www.excelforum.com/showthread.php?threadid=27238 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set a variable in Excel and loop
Frank,
Don't follow the explanation at all as I don't see any other sheet, where I is used, how VarCount equates to your example, etc., so this is a real long shot Dim varCount As String VarCount = 5 Dim I As Integer For I = 1 To 10 Step 1 Range("B" & I).FormulaR1C1 = "=Sheet1!R[" & VarCount & "]C" Range("C" & I).FormulaR1C1 = "=Sheet1!R[" & VarCount & "]C" VarCount = Varcount + 1 Next I End Sub -- HTH RP "frankeps" wrote in message ... Dim varCount As String VarCount = 5 Dim I As Integer For I = 1 To 10 Step 1 Range("B1").Select ActiveCell.FormulaR1C1 = "=Sheet1!R[VarCount]C" Range("C1").Select ActiveCell.FormulaR1C1 = "=Sheet1!R[VarCOunt]C" VarCount = Varcount + 1 Range("D1").Select Next I End Sub Well I hope that for the pro's here this is clear and know what the answer is, well just to explain, in sheet Sheet1 starting on collum B1 down there are names which i want to "put" in another sheet at cell B1 and then print this page, then the B2 at sheet1, then B3, so to make a long story short, the vat Varcount must be a number value, if i put 1 at where VarCount is the macro will work but print the value of Sheet1!R[1] ten times :) So the outcome must be that it's Sheet1!R[1], Sheet1!R[2], Sheet1!R[3] ect. Hope somebody here has an answer. Thanks. -- frankeps ------------------------------------------------------------------------ frankeps's Profile: http://www.excelforum.com/member.php...o&userid=15710 View this thread: http://www.excelforum.com/showthread...hreadid=272381 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to set a variable in Excel and loop
Hi
you don't have a print routine by now. dow you mean: Dim varCount As String VarCount = 5 Dim I As Integer For I = 1 To 10 Step 1 Range("B1").FormulaR1C1 = "=Sheet1!R[" & VarCount & "]C" Range("C1").FormulaR1C1 "=Sheet1!R[" & VarCount & "]C" VarCount = Varcount + 1 activesheet.printout Next I End Sub "frankeps" wrote: Dim varCount As String VarCount = 5 Dim I As Integer For I = 1 To 10 Step 1 Range("B1").Select ActiveCell.FormulaR1C1 = "=Sheet1!R[VarCount]C" Range("C1").Select ActiveCell.FormulaR1C1 = "=Sheet1!R[VarCOunt]C" VarCount = Varcount + 1 Range("D1").Select Next I End Sub Well I hope that for the pro's here this is clear and know what the answer is, well just to explain, in sheet Sheet1 starting on collum B1 down there are names which i want to "put" in another sheet at cell B1 and then print this page, then the B2 at sheet1, then B3, so to make a long story short, the vat Varcount must be a number value, if i put 1 at where VarCount is the macro will work but print the value of Sheet1!R[1] ten times :) So the outcome must be that it's Sheet1!R[1], Sheet1!R[2], Sheet1!R[3] ect. Hope somebody here has an answer. Thanks. -- frankeps ------------------------------------------------------------------------ frankeps's Profile: http://www.excelforum.com/member.php...o&userid=15710 View this thread: http://www.excelforum.com/showthread...hreadid=272381 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop with variable name? | Excel Discussion (Misc queries) | |||
Creating a formula using the loop variable | Excel Programming | |||
Creating a formula using the loop variable | Excel Programming | |||
Excel VBA Loop & Variable Reference | Excel Programming | |||
Re-assigning the value of a variable for a for loop from | Excel Programming |