| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to know the active column is empty ?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to know the active column is empty ?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to know the active column is empty ?
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to know the active column is empty ?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mark active row in column A (VB question) | Excel Discussion (Misc queries) | |||
| How do I highlight the active row and column headers? | Setting up and Configuration of Excel | |||
| How I can change colour of row and column which are active ? | Excel Discussion (Misc queries) | |||
| macro- move down to empty cell & active worksheet | Excel Worksheet Functions | |||
| How to locate the Row and Column of an Active Cell | Excel Discussion (Misc queries) | |||
Linear Mode
