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

VBA - exporting serial letters to single documents 0
Hide text in MSWord 2013 using macro 1
Shed some light on this WS_Calculate macro. 3
List Listbox items in column by macro 0
Single line of code with line separator 5
Finding range 6
Match and Extract Data 1
How to do this with macro? 2

Top