Thread: column count
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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