Thanks for the reply but your is changing the number to 0 (Zero) and alsoshowing the msgbox each time the code is run