column count
 

just curious:

is there a way to get the number of columns using column numbers instead of
letters?

columns("K:BR").count
returns 60

but i'd like to use the column numbers instead.

--


Gary

column count
 

You can use .column with cells

These formats also work

a = Range("A3:A7").Count

Returns 5

b = Range(Cells(1, 1), Cells(3, 3)).Count

Returns 9

"Gary Keramidas" wrote:

just curious:

is there a way to get the number of columns using column numbers instead of
letters?

columns("K:BR").count
returns 60

but i'd like to use the column numbers instead.

--


Gary

column count
 

? columns("K").Resize(,60).count
60


? Range(columns(11),columns(11+59)).count
60

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
just curious:

is there a way to get the number of columns using column numbers instead
of letters?

columns("K:BR").count
returns 60

but i'd like to use the column numbers instead.

--


Gary

column count
 

got it, thanks

--


Gary


"Joel" wrote in message
...
You can use .column with cells

These formats also work

a = Range("A3:A7").Count

Returns 5

b = Range(Cells(1, 1), Cells(3, 3)).Count

Returns 9

"Gary Keramidas" wrote:

just curious:

is there a way to get the number of columns using column numbers instead of
letters?

columns("K:BR").count
returns 60

but i'd like to use the column numbers instead.

--


Gary

column count
 

thanks, to, i knew there was a way, just couldn't remember to use range.

--


Gary


"Tom Ogilvy" wrote in message
...
? columns("K").Resize(,60).count
60


? Range(columns(11),columns(11+59)).count
60

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
just curious:

is there a way to get the number of columns using column numbers instead of
letters?

columns("K:BR").count
returns 60

but i'd like to use the column numbers instead.

--


Gary

column count
 

Gary,

Maybe I'm missing something, but if you already have the column numbers, why
can't you just subtract one from the other to get number of columns? E.g.,

Function NumCols(Col1 As Long, Col2 As Long)
NumCols = Abs(Col1 - Col2) + 1
End Function


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
just curious:

is there a way to get the number of columns using column numbers instead
of letters?

columns("K:BR").count
returns 60

but i'd like to use the column numbers instead.

--


Gary

column count
 

yes, chip, i thought of that a little bit ago. thanks for pointing that out,
too.
--


Gary


"Chip Pearson" wrote in message
...
Gary,

Maybe I'm missing something, but if you already have the column numbers, why
can't you just subtract one from the other to get number of columns? E.g.,

Function NumCols(Col1 As Long, Col2 As Long)
NumCols = Abs(Col1 - Col2) + 1
End Function


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
just curious:

is there a way to get the number of columns using column numbers instead of
letters?

columns("K:BR").count
returns 60

but i'd like to use the column numbers instead.

--


Gary