using macro to copy paste
 

hi....

I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4
at sheet 2 without open sheet 2.
Can anyone help me on this..

rgds

using macro to copy paste
 

Range("A1:A4").Copy Destination:=Sheets("Sheet2").Range("A1")

Regards,
Stefi

€žramzi€� ezt Ã*rta:

hi....

I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4
at sheet 2 without open sheet 2.
Can anyone help me on this..

rgds

using macro to copy paste
 

Please follow following steps
1. add control toolbox to the toolbar (toolbarrightclickcontrol toolbox)
2.add a command button on worksheet 1
3.Right click command buttonview code
4.then add following code in the code window:-

Private Sub CommandButton1_Click()
dim i as integer
For i=1 To 4
Application.Worksheets("sheet2").Cells(i, 1).Value= Application.
Worksheets("sheet1").Cells(i, 1).Value
next
End Sub

Now You got it!

Have a happy time.....




Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

--
Chris
------
Convert your Excel spreadsheet into online calculator.
http://www.spreadsheetconverter.com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1

using macro to copy paste
 

Thank you Stefi...

"Stefi" wrote:

Range("A1:A4").Copy Destination:=Sheets("Sheet2").Range("A1")

Regards,
Stefi

€žramzi€� ezt Ã*rta:

hi....

I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4
at sheet 2 without open sheet 2.
Can anyone help me on this..

rgds

using macro to copy paste
 

You are welcome! Thanks for the feedback!
Stefi

€žramzi€� ezt Ã*rta:

Thank you Stefi...

"Stefi" wrote:

Range("A1:A4").Copy Destination:=Sheets("Sheet2").Range("A1")

Regards,
Stefi

€žramzi€� ezt Ã*rta:

hi....

I would like to copy my data at location A1:A4 sheet 1 and past at A1:A4
at sheet 2 without open sheet 2.
Can anyone help me on this..

rgds