Re: column count

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
news:eWLR7tFWHHA.1036@xxxxxxxxxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: Linking files (Word)
    ... Word MVP web site http://word.mvps.org ... > answere the puzzle of missing pages ... > My objective is to try to have a document that is like a book, linking ...
    (microsoft.public.word.docmanagement)
  • Re: missing lines on Image Writer
    ... the lower part of lower case letters is not ... one pin is broken, and I have some missing lines. ... Next I'd check the set of DIP switches under the top cover, ... remove it and clean it. ...
    (comp.sys.apple2)
  • Re: Help with Latin marks and contractions
    ... You'll notice that the various contraction and suspension marks are ... specific letters - most of these marks just indicate that something is ... missing, but not precisely what. ... indicating the exact missing letters is the upwards and backwards curl ...
    (soc.genealogy.medieval)
  • Re: Web site vs Web Application Project
    ... In one of my projects I use the ajax control toolkit. ... web site, but this reference is not stored anywhere, ... I find it strange to include this dll file in source controll, ... of errors because of the missing dll, but there is nothing telling me ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Comparable interface
    ... Before Java 5.0: ... resist the temptation to just subtract ... does anybody recommend a really good web site which covers the more ... the term "advanced concepts of java" i9s somewhat ...
    (comp.lang.java.programmer)