is it possible to Restrict Find & Replace to 1 column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 27 May 2005 22:59 GMT

I need to Find and Replace values in a Column

Same data also exists in other columns - so I would like to restrict the
Find and Replace to
a specified column

I need to do this in a Macro ie. popup a text box

Reply to this Message

JE McGimpsey - 27 May 2005 23:04 GMT

Just select the column before doing the F&R.

> I need to Find and Replace values in a Column
>
[quoted text clipped - 3 lines]
>
> I need to do this in a Macro ie. popup a text box

Reply to this Message

Simon - 28 May 2005 22:23 GMT

No, that dosen't work

Also replaces values that exist in other columns !

This is the Macro I recorder

Sub Macro2()
Columns("W:W").Select
Selection.Replace What:="740", Replacement:="989", LookAt:=xlWhole, _
SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

Other columns with 740 in it are also replaced with 989

> Just select the column before doing the F&R.
>
[quoted text clipped - 5 lines]
> >
> > I need to do this in a Macro ie. popup a text box

Reply to this Message

JE McGimpsey - 29 May 2005 00:16 GMT

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

> No, that dosen't work

Reply to this Message

Simon - 29 May 2005 09:36 GMT

I'm using Office XP Pro - XL2002 SP2

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

> Does for me. XL04, XL03.
>
[quoted text clipped - 10 lines]
>
> > No, that dosen't work

Reply to this Message

Simon - 29 May 2005 16:17 GMT

Thanks

Works ok with 2002 SP3

> Does for me. XL04, XL03.
>
[quoted text clipped - 10 lines]
>
> > No, that dosen't work

Reply to this Message