Excel formula to VBA code conversion

S

secure

Joined
Jan 9, 2010
Messages
1
Reaction score
0
Hi all,
I just registered to this forum, sorry to start with a question.
I have written two formulas in excel and want to extend to many cells in a certain interval and generalize to other similar worksheets. So, I need to write them as vba code. The formulas:

=INDEX('sheet1'!$A2:$BI$7000,MATCH(MAX('sheet1'!I2:I7),'sheet1'!I2:I7,0),COLUMN('sheet1'!A1))

=IF(C3=W$3,100,IF(C3<W$4,TREND($V$3:$V$4,W$3:W$4,C3),IF(C3=W$4,85,IF(C3<W$5,TREND(V$4:V$5,W$4:W$5,C3),IF(C3=W$5,5,IF(C3<W$6,TREND($V$5:$V$6,W$5:W$6,C3),0))))))

I appreciate if any1 can help me to come up with vba codes.

thanks in advance
 

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

difficulty with percentage from worksheet as seen by VBA 1
How to alter the code to copy to the same exact cell destination? 1
Use array/braces **WITHIN** a formula? 3
Need Alternate Code or Formula 9
I can't get this to work 4
Calculating formula ..circular references 1
Weird Sorting Behavior 1
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value) , 2

Top