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
"Jacob Skaria" wrote:

and if you have formulas returning blank to be considered as blank then

Application.COUNTBLANK(Activecell.EntireColumn)=Ro ws.Count

--
Jacob


"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