I'm using Office XP Pro - XL2002 SP2

I'll see if we have a machine 2003 on it!

"JE McGimpsey" wrote in message
...
Does for me. XL04, XL03.

Your macro works fine as well. Only replaces 740 in column W.


What happens when you don't select:

Sub Macro3()
Columns("W:W").Replace _
What:=740, _
Replacement:=989, _
LookAt:=xlWhole
End Sub

In article ,
"Simon" wrote:

No, that dosen't work