Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text/number formating question
Everything on the sheet is formatted as text but all the text is
numbers. Treat everything as strings in the code. Problem: Looking for the string "29" in the range Buddies. A=29 where A is a string variable. All of the range Buddies is formated as text although it is all numbers. Set Third = Buddies.Find(what:=A, lookat:=xlWhole) Doesn't find string A Set Third = Buddies.Find(what:=Val(A), lookat:=xlWhole) DOES find string A Why is this? I'm looking for a string "29" in a range of strings but can only find it if I look for a value. It's confusing. John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can this be done??? Formating Question | Excel Discussion (Misc queries) | |||
Formating Question | Excel Discussion (Misc queries) | |||
Vlookup link to pivot - text/number question | Excel Discussion (Misc queries) | |||
copying a cell and changing the formating from number to text | Excel Discussion (Misc queries) | |||
Formating question | Excel Discussion (Misc queries) |