Thread: Help on Code Snippet Error {Val function}
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
  
Posts: 829
Default Help on Code Snippet Error {Val function}
"Tim Childs" wrote:
I have a test on a cell which is used on a large block of data that can
contain any items e.g. text numbers, formulae etc as follows
Val(.Cells(iFirstDataRow, iTestCol))

When I use it I get an overflow error when the cell contains ("13 E04 01")
When I change the text value
?Val("13 G04 01")
returns 13

What is being computed in the overflow-errored case?

Might be a coincidence. What are the values of iFirstDataRow and iTestCol
when you get the error?


Reply With QuoteReply With Quote