| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get a macro to opperate from a different sheet
I am tring to set up a macro on sheet 11 that will change values in sheet 13
of my work book. I have set up a button on sheet13 that transfers values from 1 range of cells to another range of cells. Is it posible to have the button work from sheet 11 instead of sheet 13. This is the macro I have for sheet 13. Thanks for your help regards Chris Sub update() ActiveSheet.Range("I20:I23").Copy Range("F20").Select Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get a macro to opperate from a different sheet
untested, but give it a try
Worksheets(11).Range("I20:I23").Copy worksheets(13).Range("F20").PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub -- Gary Keramidas Excel 2003 "Chris" wrote in message ... I am tring to set up a macro on sheet 11 that will change values in sheet 13 of my work book. I have set up a button on sheet13 that transfers values from 1 range of cells to another range of cells. Is it posible to have the button work from sheet 11 instead of sheet 13. This is the macro I have for sheet 13. Thanks for your help regards Chris Sub update() ActiveSheet.Range("I20:I23").Copy Range("F20").Select Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get a macro to opperate from a different sheet
Dear Chris,
Just add this, Worksheets("Sheet13").Activate and then you macro will be Sub update() Worksheets("Sheet13").Activate ActiveSheet.Range("I20:I23").Copy Range("F20").Select Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub Regards "Chris" wrote: I am tring to set up a macro on sheet 11 that will change values in sheet 13 of my work book. I have set up a button on sheet13 that transfers values from 1 range of cells to another range of cells. Is it posible to have the button work from sheet 11 instead of sheet 13. This is the macro I have for sheet 13. Thanks for your help regards Chris Sub update() ActiveSheet.Range("I20:I23").Copy Range("F20").Select Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get a macro to opperate from a different sheet
Hi Garry
Thanks for that, had to change it a little in the first part from Worksheet(11) to Worksheet(13). "Gary Keramidas" wrote: untested, but give it a try Worksheets(11).Range("I20:I23").Copy worksheets(13).Range("F20").PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub -- Gary Keramidas Excel 2003 "Chris" wrote in message ... I am tring to set up a macro on sheet 11 that will change values in sheet 13 of my work book. I have set up a button on sheet13 that transfers values from 1 range of cells to another range of cells. Is it posible to have the button work from sheet 11 instead of sheet 13. This is the macro I have for sheet 13. Thanks for your help regards Chris Sub update() ActiveSheet.Range("I20:I23").Copy Range("F20").Select Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to move rows from one sheet to another sheet (macro) | Excel Discussion (Misc queries) | |||
| macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
| HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
| Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions | |||
Linear Mode
