I think i know what my problem is, my sheet is protected! ahaha! i forget tounlock before running the code.. sorry for my stupidity.. and thanks for thereplies