automate division to each respective cell

[josehm]

So I'm trying to write a macro that will divide H (Force) from G (meters) , up to some "lastrow."
I tried using this for loop that I thought would translate to each respective cell, but instead it just kept the "=H2/G2" function.
Code below:

Please Login or Register  to view this content.

I cant figure out what I should put for the formula to say that I would want it to go from H2/G2, H3/G3 to "last row" respectively.

If anyone could help, I'd really appreciate it, thanks.

[Pauleyb]

Unless you are using a bunch of other stuff for the macros, I would recommend using a table. It will auto-fill a formula you put in the first row down to the last row automagically. Highlight your data and hit Ctrl-T.

Other than that
Range("I" & i).Formula = "=H"&i&"/G"&i

Just like you had it on the left side of the equation.

[bulina2k]

Hello,

Or you can use the R1C1 formula:

Please Login or Register  to view this content.

Or you could avoid loping and use .FillDown after

Please Login or Register  to view this content.

much faster as no looping involved!

[josehm]

Pauley,
Thanks for the response -- I'm planning to average the data after they are averaged and there are a total of 11690 rows, which is prone to fluctuate given the form of data collection.

Given that number, it seems unfeasible to highlight the columns -- I tried "=H"&i&"/G"&i as well as a couple variations; however I run into the error "expected: End of statement", or some other error.

[josehm]

This worked perfectly, Thanks!

[Rick Rothstein]

Or you could avoid loping and use .FillDown after

Please Login or Register  to view this content.

much faster as no looping involved!

You could also do this part with a single line of code...

Please Login or Register  to view this content.

[Pauleyb]

Given that number, it seems unfeasible to highlight the columns

Actually, Ctrl-T automatically selects the block of numbers and then brings up a dialog box for you to refine as necessary.

I tried "=H"&i&"/G"&i as well as a couple variations; however I run into the error "expected: End of statement", or some other error.

Ahh, yes, I forgot to add spaces around the ampersands. Sounds like you have a solution, but if you see that error again, that's why.