View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JBeaucaire[_130_] JBeaucaire[_130_] is offline
external usenet poster
 
Posts: 27
Default Simple question?? Nested ifs on one line

How about:
========
If OneH < "" And OneH = YNewH The Goto DisplayMsg
========

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"laavista" wrote:

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!