Re: One Nest Too Many - Help!

in such case ,it is preferable to do programming in VB code,back side


that will help run programme more smooth..

--
smd11
-----------------------------------------------------------------------
smd111's Profile: http://www.excelforum.com/member.php...fo&userid=2750
View this thread: http://www.excelforum.com/showthread.php?threadid=47016

"In such case" it is bulex! What exactly is the advantage of using VBA in
this case particular circumstance appart from:

1) slower execution
2) need to ensure the user enables macros upon openning the file
3) ensure that user has sufficient rights to set security level to Medium
4) less flexibility
5) higher risk of error

Remember: the macro will need to be executed each time the involved ranges
change (Change or/and Calculate event of the Sheet/Sheets will probably need
to be used), that is already taken care of by the formula and since it is
not volatile it won't recalculate on every recalculation in the workbook.

You try it in VBA and see if it is better ;-)

Regards,
KL


"smd111" <smd111.1vtn6a_1127495103.8291@excelforum-nospam.com> wrote in
message news:smd111.1vtn6a_1127495103.8291@excelforum-nospam.com...
>
> in such case ,it is preferable to do programming in VB code,back side
>
>
> that will help run programme more smooth...
>
>
> --
> smd111
> ------------------------------------------------------------------------
> smd111's Profile:
> http://www.excelforum.com/member.php...o&userid=27508
> View this thread: http://www.excelforum.com/showthread...hreadid=470166
>