dothisotherwork may receiving the variable ByRef(by default).


Here's a good example

http://www.cpearson.com/excel/byrefbyval.aspx

Please use a code tag for vba code.