Find and Replace

Hi,

I am trying to look through some cells and replace "," with ".".

I need this to happen on worksheet change event.

I only want it to be fired though when specific cells have been changed.

Please see code below.

Please Login or Register  to view this content.

I am getting Error Code -2147417848(80010108) Method Range of Object Worksheet Failed

If i put this code on a button click it works fine. It appears to be when i try to restrict the cells. Any help would be much appreciated.

Please Login or Register  to view this content.

Kind Regards

I believe Worksheet_Change event is not located in Sheet1. What causes an error method Intersect. One of the options would work:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.