View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HelpEachOther HelpEachOther is offline
external usenet poster
 
Posts: 3
Default 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