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"))
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.