change all instances of Queensland to QLD

[fitful_thought]

Hi,

I want to change all instances of Queensland to QLD.

What's the easiest way to do that, please, with a macro.

Thanks,

DL

 

[bcmiller]

You don't really need code to do this, you can simply use find an
replace (control + I). If you do need a macro though you can adap
this code which has been taken straight from the help file:

Worksheets("Sheet1").Columns("A").Replace _
What:="Queensland", Replacement:="QLD", _
SearchOrder:=xlByColumns, MatchCase:=True

Cheers,

B

 

[fitful_thought]

Many thanks for your help.



DL