slowokan
New Member
- Joined
- Dec 6, 2011
- Messages
- 19
Hi everybody.
I have a very simple problem. I want to assign a macro which copies some cells and pastes to next column. The button for this macro will be on Sheet1, but the macro will copy-paste the cells in Sheet3. I don't want the macro to select the Sheet3 and do the copy-paste thing. I want it work without activating the Sheet3. I want the file always stay on Sheet1.
The macro, I've created, is the following, but it selects Sheet3 and does the copy-paste.
Is it possible to create a macro without activating the other Sheet?
Thanks in advance, guys..
I have a very simple problem. I want to assign a macro which copies some cells and pastes to next column. The button for this macro will be on Sheet1, but the macro will copy-paste the cells in Sheet3. I don't want the macro to select the Sheet3 and do the copy-paste thing. I want it work without activating the Sheet3. I want the file always stay on Sheet1.
The macro, I've created, is the following, but it selects Sheet3 and does the copy-paste.
Code:
Sub DENEME()
'
' DENEME Macro
'
'
Sheets("Drafts").Select
Range("Z10:AA46").Select
Selection.Copy
Range("X10:Y10").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Is it possible to create a macro without activating the other Sheet?
Thanks in advance, guys..
Last edited by a moderator: