create module
 

re below:

that is to say, is there any way to alter code while
running code

create module
 

Hi Rick. Yes you can.

Set a reference to "Microsoft Visual Basic for Applications Extensibility" and visit this web site

http://www.cpearson.com/excel/vbe.ht

HTH