Copy cell range

[Carlos Alberto Santos]

Does have some function to copy a range of cells of a worksheet to another?

Ex.:

a b c d
1 xxx xxx xxx xxx
2 xxx xxx xxx xxx
3 xxx xxx xxx xxx


=copyrange(a1:d3)

 

[Don Guillett]

functions dont' do that. You need a macro
range("a1:a4").copy range("b2")

 

[Alan Beban]

Does have some function to copy a range of cells of a worksheet to another?

Ex.:

a b c d
1 xxx xxx xxx xxx
2 xxx xxx xxx xxx
3 xxx xxx xxx xxx


=copyrange(a1:d3)

In the target range, e.g., h5:k7, array enter (i.e., enter with
Ctrl+Shft+Enter instead of just Enter) =a1:d3

Alan Beban

 

[Gord Dibben]

Assume A13 is on sheet1

Select a range the same size on sheet2

In active cell type =sheet1!a1:d3 and hit CRTL + SHIFT + ENTER

Gord Dibben Excel MVP

On Tue, 7 Sep 2004 06:49:08 -0700, Carlos Alberto Santos <Carlos Alberto