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.


"pol" wrote:

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