Accessing Isblank In Vba
-
-
-
Re: Accessing Isblank In Vba
vba has it's own methods so the worksheet function is not supported via the object model.
try either of these
[vba] If Cells(RowIndex, ColIndex) = "" Then
If Len(Cells(RowIndex, ColIndex)) = 0 Then
[/vba] -
Re: Accessing Isblank In Vba
Quote from Om Avataar
Do you use some Loop? The best way for it:
orOr you can Access to IsBlank function by:
But I suggest you to use SpecialCells method if it's possible.
-
Re: Accessing Isblank In Vba
Om
You know a great way to see if code is valid? Try it.:)
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!