View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sonnich Sonnich is offline
external usenet poster
 
Posts: 13
Default Test for empty cell

Hi!

I have a sheet, where I have a list of integers - if present - the
field might be empty.
How do I detect whether it is empty?

Using
r = MyFile.Sheets(1).Cells(i, 4)
and later using r cuases problems, I'd like to set it to -1 in cases
where it is empty.

I get the file from elswhere, the contest of it is unknown

BR
Sonnich