View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default delete vbcode dynamically


"keepITcool" wrote in message
ft.com...
re should't
maybe. i'm confused now :)


You may be confused, but I agree absolutely with you. There is a method, so
use it.

important:
the newly created events could interfere with running code.
so disable events before adding the code lines.


Excellent point!

syntax..
I suggest OP uses a string variable. Set that. Then pump it.
makes for more readable code anyway.


Agree again. That is how I do it. It is also how I create formulas in VBA,
it also makes debugging far easier.