replace one set of numbers with another
 

I want to be able to put in the code and it replace it with a phone number.
Is there any way to do this?

replace one set of numbers with another
 

bequa

You can use Tools Autocorrect to do that through the UI. If you want to
do it in VBA, you would use the Worksheet_Change event. Post back if you
need more information.

--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

bequa wrote:
I want to be able to put in the code and it replace it with a phone
number. Is there any way to do this?