Displaying the outcome of a Formula in a message Box VBA

[darby88]

Hello all,

I am new to VBA and have a little problem. So i will explain what my macro does and then what i want it to do to give you guys a clear picture.

What It does : it sums all the numbers in column B that have a "B" corresponding to them in Column A into Cell C1
it sums all the numbers in column B that have a "S" corresponding to them in Column A into Cell D1
then it finds the difference D1-C1 into E1
then it multiplies E1 by 10 (E1*10) to F1
and it finally Displays the value of F1 in a MsgBox

What i want it to do : I want the code to carry out the same process but with out displaying anything in cells C1,D1,E1 and F1
I just want the final answer which is in F1 to be displayed in a msgbox and nowhere else.

I have attached the workbook to hopefully make it a bit clearer, i know im not the best at explaining things

Thanks

Darby

[rylo]

Hi

Please Login or Register  to view this content.

rylo

[darby88]

ty Rylo you made it look easy