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