Copying Data OR Selecting Columns In Pieces
 

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!

--
Best Regards,

Faraz

Copying Data OR Selecting Columns In Pieces
 

A sort of OFFSET?
--
Best Regards,

Faraz


"Faraz A. Qureshi" wrote:

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!

--
Best Regards,

Faraz

Copying Data OR Selecting Columns In Pieces
 

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
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

A sort of OFFSET?
--
Best Regards,

Faraz


"Faraz A. Qureshi" wrote:

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!

--
Best Regards,

Faraz