I would have to disagree. I am one of these so called novices that use
VBA at my company. VBA should be encouraged. It has saved me and my
company countless hours. Sure I make errors in programming but I am
sure we all on occasion make errors on something we are working on.
This can not be avoided, we are humans. The benefits of using VBA
overwhelming outweigh not using it. I encourage all Excel users to pick
up as much VBA as possible.





tony h wrote:
It is a trade off. There is no substantially risk-free way of providing
software but VBA is about as risky as it gets.

Pointing out the risks of this to one FD his view was that spreadsheets
have only a shortlife after the person who created them has left. When
they did the next person would re-write them. The safty was in that the
author was actually operationally responsible for the numbers created
(as opposed to a programmer who wasn't) and this ensured "reasonable
reliability".

But personally I find that the degrading of the high-standards is a
real conceptual problem. Particularly when trying to evidence the
good-quality of work my work against some of the charlatans putting
themselves forward as experts.

I remember one person coming for an interview as an excel "expert" I
asked the question what "formula would you use to give the total of the
numbers in the cells A1 to A10". No answer was given to this or my other
two "make them feel confortable" questions. I despair.

Think you hit one of my nerves with this thread - better stop before I
rant!


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=490731