Calculating Contiguous Columns by Using the Column Number
Experts of the world,
The first line of code works while the numerical equivalent code does not.
What is the syntax for calculating a group of contiguous columns using numerics instead of alpha.
Thanks for any support
Columns("IEL:IEO").Calculate Columns(6226, 6229).Calculate
sdruley
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
Columns(6226).resize(,4).Calculate
One of the best programmers in Europe
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
SDruley 
Register To Reply
Bookmarks