Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting 2 different pieces of data in 2 different columns | Excel Worksheet Functions | |||
SUM columns based on 2 pieces of logic | Excel Programming | |||
count pieces of records meet conditions in different columns | Excel Worksheet Functions | |||
combining 2 pieces of text from 2 columns | Excel Worksheet Functions | |||
moving columns and selecting for copying | Excel Programming |