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