I will give you a part clue you are mixing up Sheet1 with "Sheet1" and are not recovering the row reference correctly.
Second part of the clue will be revealed after you have tidied up your post by editing and putting all code between code tags as required by forum rules.
Hows that for a bargain offer ?