| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic sheet copy
I wondered if anyone could help me modify this line of code,
so instead of it copying the sheet with index 1 it would be dynamic, so that the user could input a string and this is the sheet that would be copied. mybook.Worksheets(1).Copy after:= _ bsebk.Sheets(bsebk.Sheets.Count) The routine is based around Ron de Bruin's sheet copy macro, I am just trying to get to grips with generalising it. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheet with dynamic chart? | Charts and Charting in Excel | |||
| Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
| Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
| Reference / Copy Dynamic Data | Excel Discussion (Misc queries) | |||
| How to Copy worksheet to new workbook with dynamic name? | Excel Programming | |||
Threaded Mode
