| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Counta with a range
I am trying to look at a range of cells to determine if the row is empty
within this range. But the code below is only looking at the first cell, not the selected range. Do Empty_Check = Application.CountA(Cells(ActiveCell.Row, 1).Range("B1:N1").Select) MsgBox (Str(Empty_Check)) ActiveCell.Offset(1, 0).Range("A1").Select Loop Until Empty_Check = 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountA | Excel Discussion (Misc queries) | |||
| =sign(--counta(range)) not working righ t | Excel Worksheet Functions | |||
| using COUNTA | Excel Discussion (Misc queries) | |||
| counta | Excel Worksheet Functions | |||
| COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions | |||
Threaded Mode
