Posted to microsoft.public.excel.programming

Carolyne[_2_] Carolyne[_2_] is offline

external usenet poster

Posts: 2

Selecting previous worksheet

I'm trying to create a macro to add a new worksheet and select the
previous worksheet to copy it. I can only select by specific name i
just want whichever sheet is previous. Can anyone help.
This is what i have so far

Application.ScreenUpdating = False
d$ = Format(Now, "dd.mm.yy")
Sheets.Add
Sheets("sheet1").Select
Sheets("Sheet1").Name = d$

The line below is where the problem is.

Sheets("12.05.04").Select
Cells.Select
Selection.Copy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting a cell for fill-in by previous cells	Carrie	Excel Discussion (Misc queries)	2	July 8th 08 04:44 PM
Moving to Previous Worksheet	Zootie	Excel Worksheet Functions	1	October 4th 06 03:28 PM
Go back to previous worksheet	BarryL	New Users to Excel	2	May 5th 05 01:38 AM
Selecting previous worksheet	Carolyne[_2_]	Excel Programming	5	May 19th 04 01:49 PM
reference to previous worksheet	Daniel Lidström	Excel Programming	2	December 16th 03 07:34 PM

All times are GMT +1. The time now is 10:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us