You can do it with one command:

with worksheets("Sheet1")
.range("A1").Copy .Range("C1")
End With


--
Regards,
Tom Ogilvy


"geebee" wrote:

hi,

i have some programming in sheet1 like:

range("A1").select
selection.copy
range("C1").select
selection.paste

right now the code only works if i make the code go to the sheet firt like:
sheets("sheet1").select

i would like to know how i can stay on my current sheet_new and have the
code execute without having to actually go to or put focus on sheet1 as made
possible by the sheets("sheet1").select


thanks in advance,
geebee