| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy to any active sheet
I am recording a macro to copy a cell in a specific sheet to whatever cell
the cursor is on. I am successful as long as I run the macro in the sheet where I recorded it, but if I need to run it on another sheet, it of course is going back to the sheet where it was recorded due to the Sheets("Sheet Name").Select command. How do I modify the code so it will copy to whichever sheet the cursor is on? -- Kat Wood OHSU ITG |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro to copy to any active sheet
Do not need to select and copy.
This will do the same thing............. ActiveCell.Value = Sheets("specificsheet").Range("A1").Value Edit to suit your sheetname and range Gord Dibben MS Excel MVP On Thu, 30 Oct 2008 15:44:00 -0700, Kat Wood wrote: I am recording a macro to copy a cell in a specific sheet to whatever cell the cursor is on. I am successful as long as I run the macro in the sheet where I recorded it, but if I need to run it on another sheet, it of course is going back to the sheet where it was recorded due to the Sheets("Sheet Name").Select command. How do I modify the code so it will copy to whichever sheet the cursor is on? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need macro to copy active sheet to a new workbook | Excel Programming | |||
| copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
| Macro to copy active sheet and email to distribution list | Excel Programming | |||
| Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Linear Mode
