Isblank function not working in VBA

[Guest]

Why does this not work:

Application.WorksheetFunction.ISBLANK(Range("ProfileFirstCell").Offset(x -
1, 5))

I am getting an error message saying:
Run time error 438, Object does not support this property or method.

Thanks

EM

 

[Guest]

Try looking up the help for IsEmpty instead.

 

[Guest]

I think Isempty is for whether or not the variable was initialized. Not sure
if that is the issue here as I am not Setting a variable equal to a range. I
am applying an excel spreadsheet function to an excel range via VBA.

Thanks

EM

 

[JE McGimpsey]

I think Isempty is for whether or not the variable was initialized.
Not sure if that is the issue here as I am not Setting a variable
equal to a range. I am applying an excel spreadsheet function to an
excel range via VBA.

Try it.

If the cell contains no value or formula, the temporary variable that
implements the value property is uninitialized.

 

[Guest]

What are you trying to do with this?

 

[Dave Peterson]

Is "ProfileFirstCell" a single cell range?

If yes, then try:

if isempty(range("ProfileFirstCell").value) then
....

If it's multiple cells

if application.counta(range("ProfileFirstCell")) = 0 then
....