View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default A VB problem with a if structure

Hi, trayng the following macro:
bla bla bla
If Cells(contr, 1) = NumeroDeControl Then
comp = 1
end if
bla bla bla

an error apears (ERR 2042), this happends because in the cell( contr,1) I
have the #N/A, but we know (you and me, because VB didn't)THE IF STRUCTURE IS
FALSE so my macro should jump the comp=1
How to thell VB that no matter what kind of value are in cells(contr,1) the
if structure must continue

I've tried everithing (declaring NumeroDeControl as string didn't work, not
declaring at all NumeroDeControl neither)
HTHS
TIa