calculating formula only on active rows

[bowles]

This site has been very helpful in my programming questions so far, but I couldn't find this one on a thread yet.

I have 3 columns of information, (A) study ID (B) effect size (C) inverse variance. The rows are pasted from other worksheets where other calculations are made. They are automatically pasted into the next empty row.

After all previous calculations have been made, I need to do some more on this page. I created the code below (well, I recorded it), but it is only for the first row. I can't just paste the formula to every row because then they will not appear as blank rows for the other macros. I want the code to automatically be calculated for every row that has numbers. Thanks so much.

Please Login or Register  to view this content.

[shg]

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

[shg]

Thanks.

Maybe like this, assuming the data starts in A7:

Please Login or Register  to view this content.

[bowles]

Incredible! Thank you so much. That is just what I needed. You guys always have the answers.