| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting previous worksheet
I'm trying to create a macro that creates a new worksheet named todays
date and copys the whole of the previous sheet into it. I can only seem to select the specific sheet name does anyone know how to select the previous sheet. I have this so far d$ = Format(Now, "dd.mm.yy") Sheets.Add Sheets("sheet1").Select Sheets("Sheet1").Name = d$ The line below is where i want to select the previous sheet. Sheets("12.05.04").Select Cells.Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new worksheet that is linked to a previous one | Excel Worksheet Functions | |||
| Selecting a cell for fill-in by previous cells | Excel Discussion (Misc queries) | |||
| Moving to Previous Worksheet | Excel Worksheet Functions | |||
| Go back to previous worksheet | New Users to Excel | |||
| reference to previous worksheet | Excel Programming | |||
![Carolyne[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
