| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lower and upper case equal on spreadsheet but not equal in VB
I am trying to get these product identifiers and others similiar to it
to show as being equal. Code in the spreadsheet itself shows them equal. Code in VBA shows them as being not equal. RM92295A rm92295a RM92298A If I write A1= A2 in the spreadsheet they show as TRUE , ie, equal. However if I use this program in VBA they show as NOT EQUAL: Set Item = cells(1,1) Do Until Item.Offset(1, 0) < Item Set Item = Item.Offset(1, 0) 'MsgBox Item.Row Loop This data is being copied from a Lotus Approach database if that is relevant. Thanks for anyone's help to solve this. Don |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
| Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
| Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
| How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
| How do I change Letter case (lower to Upper) in a spreadsheet??? | Excel Discussion (Misc queries) | |||
Threaded Mode
