formulas vs macros

J

Jan Karel Pieterse

Hi ExcelFan,
using formulas in excel is much practical than using macros.
Click to expand...

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
 
B

BizMark

excelFan said:
using formulas in excel is much practical than using macros.
Any comments please?
Click to expand...

My general rule of thumb is:

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

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

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

M
 
C

CLR

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
 
Top