Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a function in VBA to find out if entire column is empty?
Hi, VBA experts:
Can anyone inform me if VBA has a function that tells if a coumn in a worksheet is empty? I wrote the following code, but it does not work. I could write some code to check each row of the column, but I believe VBA must have a function to take care of this. Please help. Thanks. Cells(3, 6).Select Range(ActiveCell, ActiveCell.End(xlDown)).Select If Selection.Value = " " Then noData = True Esle Selection.Copy End If Thank you very much. KHW |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a function in VBA to find out if entire column is empty?
Maybe...
if application.counta(range("F:F")) 0 then 'there's something in column F else 'all of F is empty end if HelpEachOther wrote: Hi, VBA experts: Can anyone inform me if VBA has a function that tells if a coumn in a worksheet is empty? I wrote the following code, but it does not work. I could write some code to check each row of the column, but I believe VBA must have a function to take care of this. Please help. Thanks. Cells(3, 6).Select Range(ActiveCell, ActiveCell.End(xlDown)).Select If Selection.Value = " " Then noData = True Esle Selection.Copy End If Thank you very much. KHW -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a function in VBA to find out if entire column is empty?
Dave: Thank you very much for your quick response. I have tried your suggestion and it works!! Thank you!!! KHW *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a function in VBA to find out if entire column is empty?
Give this a try...
Sub test() MsgBox EmptyColumn("A") MsgBox EmptyColumn("B") MsgBox EmptyColumn("C") End Sub Public Function EmptyColumn(ByVal ColumnReference As String) As Boolean Columns(ColumnReference).Select If Application.WorksheetFunction.CountA(Columns(Colum nReference)) 0 Then EmptyColumn = False Else EmptyColumn = True End If End Function -- HTH... Jim Thomlinson "HelpEachOther" wrote: Hi, VBA experts: Can anyone inform me if VBA has a function that tells if a coumn in a worksheet is empty? I wrote the following code, but it does not work. I could write some code to check each row of the column, but I believe VBA must have a function to take care of this. Please help. Thanks. Cells(3, 6).Select Range(ActiveCell, ActiveCell.End(xlDown)).Select If Selection.Value = " " Then noData = True Esle Selection.Copy End If Thank you very much. KHW |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a function in VBA to find out if entire column is empty?
Dim LastRow As Long
LastRow = 65536 If IsEmpty(Cells(LastRow, "A")) Then LastRow = Cells(LastRow, "A").End(xlUp).Row If LastRow = 1 And IsEmpty(Cells(LastRow, "A")) Then LastRow = 0 End If Returns the last row in a column with something in it. Returns zero if the entire column is empty "HelpEachOther" wrote: Hi, VBA experts: Can anyone inform me if VBA has a function that tells if a coumn in a worksheet is empty? I wrote the following code, but it does not work. I could write some code to check each row of the column, but I believe VBA must have a function to take care of this. Please help. Thanks. Cells(3, 6).Select Range(ActiveCell, ActiveCell.End(xlDown)).Select If Selection.Value = " " Then noData = True Esle Selection.Copy End If Thank you very much. KHW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL function;find string in entire column & return cell referenc | Excel Worksheet Functions | |||
How to SUM entire column, but only when adjacent cell is not empty | Excel Worksheet Functions | |||
Find Column heading and then Delete entire column | Excel Programming | |||
Is there a test to see if an entire row or column is empty? | Excel Programming | |||
Find the first empty column | Excel Programming |