Complicated Macros VS. Formulas

[Superstar31]

I'm trying to understand why people use complicated macros when a simple formula will generate the same response? I've seen it twice so far

http://www.mrexcel.com/board2/viewtopic.php?t=180792

and

http://www.mrexcel.com/board2/viewtopic.php?t=180664&highlight=

I'm assuming my lack of knowledge about macros is limiting my vision here, so please help me understand.

Thanks.

 

[SydneyGeek]

I agree with the comments here -- you use what you need to get the job done. The beauty of this Board is that you often see several ways to get the job done -- some code and some formula, in the same post.

I sometimes find that if I use summary calcs like SUMPRODUCT, they can slow the workbook down to a crawl. So, particularly if the range sizes keep changing, I tend to create the formulas in code and then convert them to values.

Denis