Counting number of columns

[gatarossi]

Dear all,

In my VBA code, I need to put a variable... The value of this variable
is the number of columns that there are values. For example:

A B C D E F G H ...
1 1 1 1 1

In this case the variable must be 5

Other Example

A B C D E F G H ...
1 1 1 1 1 1 1 1

In this case the variable must be 8

Thanks a lot!

André.

 

[Dave Peterson]

If the values are numeric:

Dim myCount as Long
mycount = application.count(worksheets("sheet9999").rows(2))

if the values are alphanumeric, use application.counta()

Remember that all formulas (including formulas that return "") will be counted
in .counta().

 

[gatarossi]

Dear Dave

Perfect!

Thanks a lot!!!

André.