change all instances of Queensland to QLD
 

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

change all instances of Queensland to QLD
 

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

--
Message posted from http://www.ExcelForum.com

change all instances of Queensland to QLD
 

Many thanks for your help.



DL





"bcmiller " wrote in message
...
You don't really need code to do this, you can simply use find and
replace (control + I). If you do need a macro though you can adapt
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,

BC


---
Message posted from http://www.ExcelForum.com/