how to know the active column is empty ?

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
 
M

Mike H

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.
 
J

Jacob Skaria

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

Application.COUNTBLANK(Activecell.EntireColumn)=Rows.Count
 
P

pol

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

to change the macros as per active cell and range 2
To find subtotal - Please help 8
Please help me to find out number of column occured 2
to replace a value in each cell of a column 6
very urgent : to write the value of next column of the same row 2
To find row is empty or not 2
To find the column with its column heading 8
Filtered drop down list 2

Top