HOW TO SELECT SPECIFIED RANGE IN MACRO

K

K

how can I select a specified range in macro. For example if I have
data in sheet (see below)

ROW A B C F G H---col
1 XX XX XX XX XX XX----data
2 XX XX XX XX XX XX
3 XX XX XX XX XX
4 XX XX XX XX XX
5 XX XX XX XX XX XX
6 XX XX XX XX XX

I want to select range (A1: last value cell in col A & col C) and then
(F1 : col F cell of same row of last value cell in col A & col H)

basically i have data in row 1 from col B to C and then in F to H and
i want to copy the row 1 data down in columns B to C and F to H till
that row in which col A have last value cell
 
M

Mark Ivey

I think it would be better to copy one column at a time to avoid other
possible issues...

You can actually set up the Macro Recorder to do most of these functions for
you.

Start the Macro Recorder, select the top cell in the column you want, then
use a CNTL + SHIFT + DOWN ARROW to capture the entire column.
Then select CNTL + C to copy the data. Select the destination cell's top
position and select CNTL + V to paste.

Repeat for each column...

See if this will work for you...

Mark Ivey
 
K

K

I think it would be better to copy one column at a time to avoid other
possible issues...

You can actually set up the Macro Recorder to do most of these functions for
you.

Start the Macro Recorder, select the top cell in the column you want, then
use a CNTL + SHIFT + DOWN ARROW to capture the entire column.
Then select CNTL + C to copy the data. Select the destination cell's top
position and select CNTL + V to paste.

Repeat for each column...

See if this will work for you...

Mark Ivey









- Show quoted text -
Click to expand...

thanks again mark. i think thats good idea
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula needed to SUM and COUNT in specific way 1
Single line of code with line separator 4
Match and Extract Data 1
Sorting, replacing data 1
Copy data into sheets 13
How to do this with macro? 2
Finding range 3
Shed some light on this WS_Calculate macro. 3

Top