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

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

? 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

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

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

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

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