Moving formulas into VBA

[brharrii]

I realize this is an incredibly simplisitc question, I've heard that it is possible to run all formulas in the background in VBA as opposed to placing them in specific cells. Normally if I wanted to sum a range of cells I would go the cell that I want to contain the answer and I would put something like:

Please Login or Register  to view this content.

and it would give me a total. is it possible to leave the cell blank and have that math in VBA somewhere?

[JBeaucaire]

Sure, you can use the Evaluate function in VBA to run a formula.

Please Login or Register  to view this content.

If you want it to be more dynamic and figure out how much data is in column C and run the formula for that many cells:

Please Login or Register  to view this content.

[brharrii]

Thank you very much! :D

---------- Post added at 12:51 PM ---------- Previous post was at 12:42 PM ----------

Hmmm, ok, I just tried it and it didn't work. I guess I should have saved the thanking till I had test it><

Anyways, is there a prefix and suffix I need on this code of some sort, Sub/ Endsub etc?

[rkey]

aye, always place your code between

Please Login or Register  to view this content.

[brharrii]

Got it,

thanks!

Sorry! I'm about a week old of self teach on VBA.

[rkey]

no problem, glad to help

[JBeaucaire]

Heh, yeah, I was just testing you, honest.