Isblank function not working in VBA
 

Why does this not work:

Application.WorksheetFunction.ISBLANK(Range("Profi leFirstCell").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

Isblank function not working in VBA
 

Try looking up the help for IsEmpty instead.

--
Anything is possible if you don''t know what you''re talking about.


"ExcelMonkey" wrote:

Why does this not work:

Application.WorksheetFunction.ISBLANK(Range("Profi leFirstCell").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

Isblank function not working in VBA
 

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

"Wood Grafing" wrote:

Try looking up the help for IsEmpty instead.

--
Anything is possible if you don''t know what you''re talking about.


"ExcelMonkey" wrote:

Why does this not work:

Application.WorksheetFunction.ISBLANK(Range("Profi leFirstCell").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

Isblank function not working in VBA
 

In article ,
ExcelMonkey wrote:

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.

Isblank function not working in VBA
 

What are you trying to do with this?

"ExcelMonkey" wrote:

Why does this not work:

Application.WorksheetFunction.ISBLANK(Range("Profi leFirstCell").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

Isblank function not working in VBA
 

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



ExcelMonkey wrote:

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

"Wood Grafing" wrote:

Try looking up the help for IsEmpty instead.

--
Anything is possible if you don''t know what you''re talking about.


"ExcelMonkey" wrote:

Why does this not work:

Application.WorksheetFunction.ISBLANK(Range("Profi leFirstCell").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

--

Dave Peterson