Copying Data OR Selecting Columns In Pieces

[Faraz A. Qureshi]

Sure would oblige if any of u experts would kindly offer me with a sample
code so as to clarify the concept of activating/selecting specific number of
columns within a range.

For instance, a code which would select the columns within a specified range
in two, as follows:

1. With range already selected (e.g. $A:$H);
2. First select columns $A:$B; Then
3. First select columns $C:$D; Then
4. First select columns $E:$F; Then
5. First select columns $G:$H; Then

The end!

 

[Faraz A. Qureshi]

A sort of OFFSET?

 

[Jacob Skaria]

Do you mean the below.. Try running this code using F8 (Step into) and see
what happens on each line OR try line by line from immediate window...

Range("A:H").select
selection.resize(,2).select
selection.resize(,4).select
selection.resize(,6).select
selection.resize(,8).select

If this post helps click Yes