View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Need help with empty cell in Macro

if (Var1 = x or var2 = y ) and not (var2 = " ") then

--
Regards,
Tom Ogilvy

"Don" wrote in message
...
set var2 in macro that returns " " when cell is empty.
Need statement that says If var1 = x or var1 = y and
var2 not " " Then

Can anyone help?