MrExcel Publishing
Your One Stop for Excel Tips & Solutions

correct syntax in VBA


Posted by Joan on July 27, 2001 1:44 PM

In my code, i.e:
If [B6] = 1 And [B17] = 1 And [A23] = 1
What if i wanted to write [A23] was empty or was not
empty?
Thanks for the assistance
Joan


Posted by steve w on July 27, 2001 7:21 PM

If [A23]=""
If Not [A23]=""

Not sure what you wanted, Try it like this

If range("A23")="" then
"Your code here
end if
If not range("A23")="" then
"your code here"
end if

steve w