Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple CountA syntax (VBA)
I have a worksheet where users are entering data from D1 to IV1 (headers); I
need to count how many entries exist so I can automatically paste entries at the next unused cell (all contiguous cells will be filled, There won't be any blanks). I tried the following, but the range reference for CountA doesn't appear to translate well (clearly, I'm not getting the proper syntax). Can anyone correct it, or provide an easy alternative in VBA? Thanks, Keith XL2003 not working: ----------------- OldApps = Excel.WorksheetFunction.CountA(Sheet3.Range("D1:IV 1")) and OldApps = Excel.WorksheetFunction.CountA(Sheet3.Range("D1:IV 1").value) Each returns the value of 1; in a cell on that worksheet, =countA(D1:IV1) evaluates to 34 (and will be growing quickly) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTA function causing syntax error in macro... | Excel Worksheet Functions | |||
question about syntax in a simple macro... | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions | |||
Syntax error (simple) | Excel Programming | |||
need help with simple syntax error | Excel Programming |