I should have remenbered that! Thanks Jim

EagleOne

On May 16, 9:54 am, "Jim Rech" wrote:
The Replace function is case sensitive.

--
Jim"Dennis" wrote in message

oups.com...
| 2003
|
| ActiveCell.Formula is =ROUND('1106'!C160,0)
|
| I am attempting to remove "Round(" then in a second step
| remove or truncate the ",0)". What I am after is the sheet and cell
| reference
| without the round function in the mix.
|
| The challenge is that:
| CellRef = Replace(ActiveCell.Formula, "Round(", "") does not replace
| "Round(".
| my guess is that XL does not want to remove "Round" as a function or
| Replace only works for one character?
|
| CellRef = Replace(ActiveCell.Formula, "R", "") works fine.
|
| What is the issue that I am missing and/or what is the best solution?
|
| TIA
|
| EagleOne
|