Creating Functions From Formula
:idea:
During thread http://www.vbaexpress.com/forum/show...abet-in-a-cell
it suddenly struck me that of the myriad ways in VBA of achieving the same end result, one particularly helpful one is creating functions that can be used repeatedly across workbooks, thus avoiding using any macros whatsoever in many workbooks.
The first solution offerered in the above thread was to avoid VBA and use standard Excel functionality (albeit creating a rather terrifying formula in the eyes of a typical Excel user) :
=MID(A1,MIN(INDEX(SEARCH(CHAR(64+ROW($1:$26)),A1&"abcdefghijklmnopqrstuvwxy z"),0)),LEN(A1))
If faced with the same (or similar) problem again later, many users start from scratch re-writing the formula (and debugging their way through nested brackets etc!) - they probably deleted or cannot find that original spreadsheet with the formula in it.
My question:
Is there a foolproof way of quickly creating a function from any Excel formula, no matter how complicated?