There are some different native functions for using VBA. There is IsEmpty,
IsMissing, IsNull, Is Nothing (space intended, argument), IsDate, IsNumeric,
IsArray, IsObject, IsArray, etc. The Help files have them listed fairly
well.

If you're trying to find if a cell is blank, you can always use the Len
function ..

If Len(Yourcell.value) = 0 then
msgbox "blank"
else
msgbox "not blank"
end if

HTH

--
Regards,
Zack Barresse, aka firefytr



"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
Hello all,

Can I use the IsBlank worksheet function in VBA? It doesn't show up in
the Application.WorksheetFunction list.

Is it part of the Analysis ToolPak? I have references in my project to
"funcres" & "atpvbaen.xls" and it is still not showing up in the list.

How do I use it, if I can?

Thanks for any help anyone can provide,

Conan Kelly