MichaelRSnow
Active Member
- Joined
- Aug 3, 2010
- Messages
- 409
Hi
Hopefully a really simple solution to my problem, i'm trying to find and replace a rate of 1.50 with 2.50, the 'fnd' value is in a textbox formatted as 0.00, as is the 'rplc' value, but the sheet where its performing this change is formatted as 0.00 (number, 2 decimal) but if you select the cell it shows as 0.0 (don't see the ending 0). Therefore it can't find 1.50 as its technically 1.5
Is there a way to get this to work WITHOUT formatting all my values to text?
Hopefully a really simple solution to my problem, i'm trying to find and replace a rate of 1.50 with 2.50, the 'fnd' value is in a textbox formatted as 0.00, as is the 'rplc' value, but the sheet where its performing this change is formatted as 0.00 (number, 2 decimal) but if you select the cell it shows as 0.0 (don't see the ending 0). Therefore it can't find 1.50 as its technically 1.5
Is there a way to get this to work WITHOUT formatting all my values to text?
VBA Code:
'Perform the Find/Replace on each row for rates
sht.Cells.SpecialCells(xlCellTypeVisible).Replace What:=fnd, Replacement:=rplc, _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
SearchFormat:=False, ReplaceFormat:=False