1 worksheet or 2?

[Rzeno91]

Hey all!

Sorry if this has been asked before, but I can't seem to find the answer.

I have around 50 command buttons I use to semi automate my strategy. I also have around 200 formulas which are used with these command buttons / working out different parameters.

Key point: currently my command buttons are on the main betangel worksheet... All my formulas.are on a separate worksheet.

My question is: for maximum performance should I have all my formulas on the betangel worksheet, or wouldn't it make any difference to have them on a separate one?

Obviously I know there won't be much difference.. I'm just asking about maximum performance.

Thanks

[ODPaul82]

Having the formulas on the same worksheet as BA should in theory be quicker but it will only be marginal and we're talking super-marginal.

The command buttons won't give any overhead until they are triggered off just remember that any VBA running behind them is a hell of a lot slower due to the fact that VBA is an interpreted language whereas the formulas are built with C++ and therefore a hell of a lot faster.

Some ways of optimising performance is if any of your formulas are doing lookups/counts/sum, only reference the cells that really need checking. For example if you do SUMIF($A2:$A1000) this will be quicker than SUMIF($A:$A) due to the fact that the latter will check every single cell in column A

[Rzeno91]

Thanks for the information, I'll definitely look into my fornulas and optimize them.

I appreciate the help