Simple calculation using a macro, help?

[andrew93hughes]

Hi, I need a macro that multiplys the values in B, D and F, and then divides them by C

I know this is probably a walk in the park for most of you, but a little help would be ideal!

[romperstomper]

Why a macro rather than a simple formula?

[SoulPrisoner]

hi there,

here you go

Please Login or Register  to view this content.

[andrew93hughes]

Thanks SoulPrisoner, this works for the function required, but when I run the macro, it debugs for the line

Please Login or Register  to view this content.

Any ideas?

[andrew93hughes]

romperstomper, I really need it to be in macro form

[SoulPrisoner]

well ofc I know where is the problem, cause i counted wrong the loop, u need to leave out the empty cells cause they fail on dividing and i failed at that....its not supposed to be +4 but just +2, so it stops on 224th row

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.