formulas vs macros
 

using formulas in excel is much practical than using macros.
Any comments please?

formulas vs macros
 

Hi ExcelFan,

using formulas in excel is much practical than using macros.

True, but some tasks are (almost) impossible to do without macros.

Macros can automate repetetive tasks too.
Even more so: with macros you can build entire applications in Excel
that drive a certain data entry/analysis process from start to finish.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

My general rule of thumb is:

If something can be done without macros (i.e. with formulas), and the end users are confident with formula manipulation/modification, I would use formulas.

If something cannot be done EASILY without macros (i.e. requires very pendulous and obscure formulae) and/or the end users for which the solution is being provided are not confident or EXPECTED to become confident in the formula manipulation/modification that may be required, I would use macros.

Obviously, if anyone wants anything done on the click of a custom button or menu, macros automatically become necessary.

MB

formulas vs macros
 

Hi excelFan...........
I see your statement as similar to "using one's Right hand is more practical
than using their Left hand".............Both formulas and macros are very
useful in Excel. Each has it's place. Some people use one where the other
might be "more practical". Sometimes one might try to avoid macros because
of Excel Version incompatibility, and/or security problems.....but they do
bring a whole new dimension of capabilities to Excel that are simply
unachievable by just using formulas.

hth
Vaya con Dios,
Chuck, CABGx3



"excelFan" wrote:

using formulas in excel is much practical than using macros.
Any comments please?

formulas vs macros
 

I'm sorry, but I totally disagree. Macros and Formulas are apples and
oranges.....


--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=525585