how to know the active column is empty ?

  • Thread starter Thread starter pol
  • Start date Start date
P

pol

Current cell is Y1 and I want to know the active column is empty . Please
adivice me to find the column is empty or not?

With thanks

pol
 
Hi,

Is this a VB question? It sounds like

Dim Emty As Boolean
Emty = WorksheetFunction.CountA(ActiveCell.EntireColumn) = 0

Will return TRUE or FALSE
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
and if you have formulas returning blank to be considered as blank then

Application.COUNTBLANK(Activecell.EntireColumn)=Rows.Count
 
Thanks for the reply and due to my concern let me ask one question, would it
work in 2003 version excel. ? Pls advice


With thanks

pol
 
Back
Top