| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Active Page Name
I have an excel macro the when a cell is triggered it creates and names a new
worksheet. what I want to do is in that worksheet run a macro that copies all from "VAT Invoice" into the active sheet. What i've recorded is Sheets("VAT Invoice").Select Range("A1:J37").Select Range("J37").Activate Selection.Copy Sheets("989989").Select ActiveSheet.Paste Sheet "980089" is the issue, as it will never be the same. The sheet name is created from Cell B4 in "VAT Invoice" How can I tell the macro to find the active worksheet name and then put the data there. Thanks for your help John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run macro although blinking cursor is active in an active cell | Excel Programming | |||
| sending active sheet by mail without macro (from Ron's page) | Excel Programming | |||
| Button to print non-active page - How? | Excel Programming | |||
| which page is active | Excel Programming | |||
| Make excel the active page | Excel Programming | |||
Threaded Mode
