| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
