Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing variable
I want to run the followingcode in specific columns, but
in several different rows. The columns will always stay the same, but the number of rows will be different each time I run the code. If Range("h2") = "Procedural" Then Range("j2").Formula = "Procedural" Exit Sub ElseIf Range("f2") 0 Then Range("j2").Formula = "Overpayment" ElseIf Range("g2") 0 Then Range("j2").Formula = "Underpayment" End If I'm using a count procedure to count number of rows in the usedrange, and figured I'd use a loop statement, but I can't see how to reference the rows as variables. Thanks, Lee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing variable
for i = 2 to 100
If Cells(i,8) = "Procedural" then Cells(i,10).Formula = "Procedural" exit Sub Elseif and so forth. Replace 100 with a variable that contains your count. -- Regards, Tom Ogilvy "Lee" wrote in message ... I want to run the followingcode in specific columns, but in several different rows. The columns will always stay the same, but the number of rows will be different each time I run the code. If Range("h2") = "Procedural" Then Range("j2").Formula = "Procedural" Exit Sub ElseIf Range("f2") 0 Then Range("j2").Formula = "Overpayment" ElseIf Range("g2") 0 Then Range("j2").Formula = "Underpayment" End If I'm using a count procedure to count number of rows in the usedrange, and figured I'd use a loop statement, but I can't see how to reference the rows as variables. Thanks, Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing another workbook using a variable for the sheet? | Excel Worksheet Functions | |||
Variable cell referencing | Excel Worksheet Functions | |||
Referencing tab based on Variable | Excel Worksheet Functions | |||
Variable Cell Referencing | Excel Worksheet Functions | |||
Referencing Variable Name Worksheets | New Users to Excel |