I have a code in Net_Rate_Sheet_1, ReplaceNet1 that replaces text values across Net Rate Sheet 1, row 2597.
The data is now = the cell should be text
Zone-9 ( To Hawaii ) = 9
Zone-17 ( To Alaska ) = 17
Zone-22 ( Intra-Alaska ) = 22
Zone-23 ( From Alaska ) = 23
Zone-25 ( From Alaska ) = 25
Zone-92 ( From Hawaii ) = 92
Zone-96 ( From Hawaii ) =96
No matter what I try, I can't get the correct replacements.
It will replace, but not reduce to JUST the number - ie 92, 96, etc.
Not sure what I'm doing wrong, all of the other replacements have worked easily.
Tried xPart & xWhole....not sure what else to do.
Can anyone help?