Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using IsBlank in VBA
Hello all,
Can I use the IsBlank worksheet function in VBA? It doesn't show up in the Application.WorksheetFunction list. Is it part of the Analysis ToolPak? I have references in my project to "funcres" & "atpvbaen.xls" and it is still not showing up in the list. How do I use it, if I can? Thanks for any help anyone can provide, Conan Kelly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using IsBlank in VBA
Did you try isempty()? -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=537027 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using IsBlank in VBA
There are some different native functions for using VBA. There is IsEmpty,
IsMissing, IsNull, Is Nothing (space intended, argument), IsDate, IsNumeric, IsArray, IsObject, IsArray, etc. The Help files have them listed fairly well. If you're trying to find if a cell is blank, you can always use the Len function .. If Len(Yourcell.value) = 0 then msgbox "blank" else msgbox "not blank" end if HTH -- Regards, Zack Barresse, aka firefytr "Conan Kelly" <CTBarbarin at msn dot com wrote in message ... Hello all, Can I use the IsBlank worksheet function in VBA? It doesn't show up in the Application.WorksheetFunction list. Is it part of the Analysis ToolPak? I have references in my project to "funcres" & "atpvbaen.xls" and it is still not showing up in the list. How do I use it, if I can? Thanks for any help anyone can provide, Conan Kelly |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using IsBlank in VBA
Btw, (posted too quickly) there are some worksheet functions that are not
available to the VBE via App.WorksheetFunction.., just Fyi. -- Regards, Zack Barresse, aka firefytr "Conan Kelly" <CTBarbarin at msn dot com wrote in message ... Hello all, Can I use the IsBlank worksheet function in VBA? It doesn't show up in the Application.WorksheetFunction list. Is it part of the Analysis ToolPak? I have references in my project to "funcres" & "atpvbaen.xls" and it is still not showing up in the list. How do I use it, if I can? Thanks for any help anyone can provide, Conan Kelly |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using IsBlank in VBA
I just realized that you might have been asking if the entire worksheet is empty... one way to check is the following code: Sub test() If ActiveSheet.UsedRange.Cells.Address = "$A$1" And ActiveSheet.Range("A1").Value = "" Then MsgBox "Clear" Else MsgBox "Not Clear" End If End Sub -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=537027 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using IsBlank in VBA
If that's the case, just use ..
If WorksheetFunction.CountA(Cells) = 0 Then msgbox "empty" Else msgbox "has data" End If The way you've shown, data can be in A1 and give a false positive. HTH -- Regards, Zack Barresse, aka firefytr "Ikaabod" wrote in message ... I just realized that you might have been asking if the entire worksheet is empty... one way to check is the following code: Sub test() If ActiveSheet.UsedRange.Cells.Address = "$A$1" And ActiveSheet.Range("A1").Value = "" Then MsgBox "Clear" Else MsgBox "Not Clear" End If End Sub -- Ikaabod ------------------------------------------------------------------------ Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371 View this thread: http://www.excelforum.com/showthread...hreadid=537027 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
isblank | Excel Worksheet Functions | |||
IsBlank | Excel Discussion (Misc queries) | |||
IF and ISBLANK | Excel Worksheet Functions | |||
IF AND ISBLANK | Excel Worksheet Functions | |||
IF(ISBLANK) | Excel Worksheet Functions |