I have data that is copied form a web based program and pasted into a excel spread sheet for printing.

The data is reduced with some find and replace code before printing, my problem that I am trying to solve is some of the data comes in the format of for example [Sick Leave] which is then replaced with Sick Leave.

Is there a find and replace code that can remove the [ ] brackets from any data that exists on the sheet.

Below is part of the code I am using to acheive results currently, I am hoping to have a bit of code that can remove the [ ] brackets and leave the Sick Leave.

PHP Code:
Selection.Replace What:="[Sick Leave]"Replacement:="Sick Leave"LookAt:=xlPart_
        SearchOrder
:=xlByRowsMatchCase:=FalseSearchFormat:=False_
        ReplaceFormat
:=False 

Thanks for any advice