software

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

gt; 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
www.jkp-ads.com
Originally Posted by excelFanusing formulas in excel is much practical than using macros.
Any comments please?

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
Hi excelFan...........
I see your statement as similar to quot;using one's Right hand is more practical
than using their Left handquot;.............Both formulas and macros are very
useful in Excel. Each has it's place. Some people use one where the other
might be quot;more practicalquot;. 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
quot;excelFanquot; wrote:

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


I'm sorry, but I totally disagree. Macros and Formulas are apples and
oranges.....--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: www.excelforum.com/member.php...oamp;userid=32258
View this thread: www.excelforum.com/showthread...hreadid=525585