Rather than changing the codename of the worksheet and rewriting all the
code

A Find/Replace only takes a second. That's the way to go.

--
Jim
"Antonio" wrote in message
...
|I have a worksheet with a codename of SPLIT.
|
| I need to use the Split function in VBA code in that workbook
|
| The worksheet SPLIT is part of an old workbook with plenty of code and
| plenty of other code refers to it.
|
| Rather than changing the codename of the worksheet and rewriting all the
| code, can I use the Split function somehow? At the moment as soon as I
type
| Split it assumes it is the worksheet object, not the function.
|
| Thanks,
|
| Antonio