EXCEL 2003 copy paste a defined range in a cell

**EXCELNOOB123** · 03-07-2011, 04:32 PM

Hi all. I am new to excel and am in need of some guidance. I currently have a cell with a dynamic range in it and need a macro to select and copy the range from the cell and paste it based on the range output of another cell. Let me give an example:

Cell a1 displays: B1:B10.
Cell a2 displays: C1:C10
I would like to make a macro that will use the range defined in cell A1 and copy paste it to a predefined cell, and then use the range defined in a2 and paste that directly below the last cell that was pasted from the ranged defined in A1. Can someone offer some insight on how to do this?

**Osvaldo Palmeiro** · 03-07-2011, 10:01 PM

Hi.
could you try this

I assumed that the destination cell will be into column F, so e.g.

A1 = B1:B10 and F1 = H1 (H1 as the destination cell from B1:B10)
A2 = C1:C10 and F2 = H2 (H2 as the destination cell from C1:C10)
. . .

for this you can type H1 into F1 and drag down as required

Please Login or Register  to view this content.

EXCEL 2003 copy paste a defined range in a cell

LinkBack

Thread Tools

Rate This Thread

Display

EXCEL 2003 copy paste a defined range in a cell

Re: EXCEL 2003 copy paste a defined range in a cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions