change all instances of Queensland to QLD

F

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
 
B

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
 
Top