Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
IF ISBLANK Function | Excel Worksheet Functions | |||
ISBLANK and OR Function | Excel Discussion (Misc queries) | |||
IF Function with ISBLANK | Excel Worksheet Functions | |||
Isblank Function not working in VBA | Excel Programming |