Advertisement

03.16.2008 at 04:33PM PDT, ID: 23245834
[x]
Attachment Details

excel - loop formula problem

Asked by sjvenz in Microsoft Excel Spreadsheet Software

Tags: microsoft office, excell, 2003, loop formula

I have the following piece of code that I use in a loop that runs over 32 rows to insert the following


j = 1
For i = 10 To 23 Step 1
Cells(i, j + 1).Select
'    Range("b10").Select
        Call sn
Cells(i, j + 2).Select
'    Range("c10").Select
        Call RT_on
Cells(i, j + 3).Select
'    Range("d10").Select
        Call RT_off
Cells(i, j + 9).Select
'    Range("j10").Select
        Call ord_time
Cells(i, j + 10).Select
'    Range("k10").Select
        Call OT
Cells(i, j + 11).Select
'    Range("l10").Select
        Call Passive
Cells(i, j + 15).Select
'    Range("p10").Select
       Call comm
Next i

sub comm()
    ActiveCell.FormulaR1C1 = "=IF(RC[-15]="""","""",IF(VLOOKUP(R10C18,BLP_Dates,2,FALSE)=0,"""",VLOOKUP(R10C18,BLP_Dates,2,FALSE)))"
    tmpValue = ActiveCell.Value
    ActiveCell.FormulaR1C1 = ""
    ActiveCell.Value = tmpValue
end sub

I have the problem that I cannot get the reference for the vlookup to also do the same, any help would be greatly appreciated. As I do not want to go back to write this for each line
Start Free Trial
[+][-]03.16.2008 at 04:38PM PDT, ID: 21139036

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.16.2008 at 04:43PM PDT, ID: 21139055

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.16.2008 at 10:08PM PDT, ID: 21139943

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.16.2008 at 10:20PM PDT, ID: 21139974

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 02:30PM PDT, ID: 21146369

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 02:39PM PDT, ID: 21146425

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 03:03PM PDT, ID: 21146603

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 03:12PM PDT, ID: 21146643

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 03:19PM PDT, ID: 21146707

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 03:21PM PDT, ID: 21146730

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 03:23PM PDT, ID: 21146757

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 03:25PM PDT, ID: 21146773

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 03:29PM PDT, ID: 21146821

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.17.2008 at 03:35PM PDT, ID: 21146876

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: microsoft office, excell, 2003, loop formula
Sign Up Now!
Solution Provided By: zorvek
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.22.2008 at 11:15PM PDT, ID: 21629732

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628