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

Originally Posted by crmpicco

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

Originally Posted by crmpicco

how do i do that with VBA?

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

Thread: Count the number of cells in a row that are not empty