I'm having trouble with a VLookup in my Excel spreadsheet because the numbers remain as strings even after I run the range through a number formatting sub-routine. I keep finding ways to convert a single string value ("123") to a long integet by assigning it to variable such as:
longVar = Clng("MyString")
But this doesn't work with a range. Any help would be greatly appreciated!