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