| 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 |
| 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 | |||
Threaded Mode
