Change Formula to Static Value in VB

I have the following code that places a formula into the cell.

Please Login or Register  to view this content.

skip is a long type variable which determines the number of rows to count down in the range.

How can I change this to place only the result of the formula into the cell?

Maybe just another line, plus you used the same cell for both halves of a range, which is overkill, just list the cell:

Please Login or Register  to view this content.

Use inbuilt fucntion application.worksheetfunction.sum

eg.

Please Login or Register  to view this content.

Originally Posted by nsorden

Thanks JBeaucaire, the use of a single cell at the top is helpful. The fomula does need to reference the range in the formula because it is calculating a weighted average.

You missed my point. You're misusing the RANGE in VBA. It should be Range(1stcell,2nd cell). You're noting the same cell twice doesn't do anything noteworthy, so there's no need to list it that way.

Please Login or Register  to view this content.

As for combining loops, of course. You can simply use one loop variable, you don't need multiples. Without seeing the sheet this applying to or knowing what's really happening with the code, I can't honestly say whether or not the "else" part could be combined like I know the first part can be:

Please Login or Register  to view this content.