View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Need help with empty cell in Macro

hi,
if var1 = "x" or var1 = "y" and var2 not isempty then

-----Original 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?
.