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

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

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