View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Simple question?? Nested ifs on one line

sub ONEline()
If OneH < "" and OneH = YNewH then goto DisplayMsg
end sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"laavista" wrote in message
...
I'm using Excel 2003.

This seems like it should be very simple, but I've tried lots of things,
and
nothing works.

I have a large amount of "checks" to do so I would like to put 2 if
statements on one line.

I'd like to put this on one line:

If OneH < "" then
If OneH = YNewH then
goto DisplayMsg
end if
end if

Your help would be GREATLY appreciated!