PDA

View Full Version : [SOLVED] Count the number of cells in a row that are not empty



crmpicco
05-18-2005, 04:05 AM
I am looking for code that will count the number of cells in a row starting from Cell C1 from left to right that are not empty.


Thankx

Bob Phillips
05-18-2005, 04:13 AM
I am looking fot code that will count the number of cells in a row starting from Cell C1 from left to right that are not empty.


=COUNTA(3:3)

crmpicco
05-18-2005, 05:03 AM
how do i do that with VBA?

Bob Phillips
05-18-2005, 05:15 AM
how do i do that with VBA?


myVar = Application.CountA(Rows("3:3"))