Thread: Excel VBA - VLookup problem referencing another sheet in the same workbook
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Excel VBA - VLookup problem referencing another sheet in the same workbook
split doesn't convert the string values you pass to it into numbers, so
doing the conversion, as you have discovered, is required (since the data in
the lookup table are apparently numbers).

--
Regards,
Tom Ogilvy

"StylinEric " wrote in message
...
purring a cint infront of CA(i) in the vlookup fixed the problem

thanks agian Tom!


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote