Error 400 - Search and Replace

This code "should" search the "pricing page" tabe and updates cells C7 to C50 workbook. Instead I am getting an error "400" Ideas?

Please Login or Register  to view this content.

I can't explain but you have to first select the worksheet then set the range as I did in the code below. I'm not sure at all this code will do what you want but you'll at least be able to test it.
Good luck
Pierre

Please Login or Register  to view this content.

The code did remove the error, but now updated every item with the same value.