How to divide 2 rows in VBA

[amitgaja007]

I am working on a VBA code wherein I have to divide 2 rows in a particular worksheet...as of now I have a very primitive code which goes through each and every cell and performs the division using nested loops...but it is a time consuming process...

So I was wondering if someone could help me with a simple code which directly divides the rows, that is:

worksheet("test").row1 = worksheet("test").row2 / worksheet("test").row3

Thanks in advance for all the help!!

[Richard Buttrey]

Hi,

How about

Please Login or Register  to view this content.

[amitgaja007]

thanks for trying...but not working

[Richard Buttrey]

thanks for trying...but not working

In that case you'll need to upload a workbook so that we can see the problem in context. I'm assuming of course that you changed the A1:A3 refs. to match your actual data.

Rgds

[amitgaja007]

i have uploaded a simple example...i need to divide the 2 rows using a direct line of code in VBA...

[shg]

Here's one way:

Please Login or Register  to view this content.

[broro183]

hi amitgaja007,

In the comment you say "row3 = row1 / row2" & Shg's post will give you:
"row3 = value in specific cell of row1 / value in specific cell of row2"

However, my guess is that you want "row3 = sum of all cells in row1 / sum of all cells in row2", which will give the same value in every cell of row 3. Am I on the right track?

Can you please try re-explaining your aim with the array formula?

Please Login or Register  to view this content.

I'm not sure if it will help as I don't understand what you need & I haven't used this before but vba has a "Range.FormulaArray Property" which may help you.

Is this for a weighted average?
Also, I'm curious, why do you want a vba solution?
I'm sure that you could design a "template" style excel file that will work with just formulae.

hth
Rob