.Characters function run-time error 438

[biznez]

Im trying to make it work with numbers but having no luck. gettimg error msg "runtime error 438 object doesnt support this property of method". Can someone please take a look? Thanks

Please Login or Register  to view this content.

[Norie]

Really not sure what you are trying to do but this will compile.

Please Login or Register  to view this content.

[biznez]

Really not sure what you are trying to do but this will compile.

Please Login or Register  to view this content.

Thanks Norie this works if values in A1 and B1 is text but it doesnt work if they are numbers

[Norie]

Any chance you could upload a sample workbook and explain what you want to do?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[MrShorty]

Are you required to use the .characters method/property? It appears to me that you are using the .characters method the same way one would use the Mid() function. I think the Mid() function will work on numbers, numbers stored as text, and the result of a function, where the .characters method only works on text literals. My thought is to replace the characters method with the mid() function

Please Login or Register  to view this content.

[biznez]

Any chance you could upload a sample workbook and explain what you want to do?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Numbers in Cell A1 is the actual 7 digit number and in cell B1 having 7 digit numbers also but "ALMOST" identical from cell A1. It can be off by 1 or 2 digits. If these 2 cells are ALMOST identical, even if its off by one or 2 digits, i would like that value from cell B1 to show up in cell C1 otherwise cell C1 is left blank. Hope i made sense. Thanks Norie

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.