Macro to copy sheet

[Guest]

I need a macro that will copy an active sheet and put it in the front of the
workbook (1st Sheet). I would also like it to put the date in cell A3. Any
suggestions? I have one that copies a sheet and places it before a specific
sheet but I'm unsure how to tell it to move it to the beginning.

Thanks,
Chance

 

[Bob Phillips]

Hi Chance,

Here is some code

ActiveSheet.Move before:=Worksheets(1)
Range("A3").Value = Format(Date, "dd mmm yyyy")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks works great! I want to have the sheet auto name to the date in cell
B3 but I would like it to be in a different format. 3/10/2205 would be March
10 for the tab name.

 

[Bob Phillips]

With Activesheet
.Name = Format(.Range("B3"),"mmm dd")
End With

--

HTH

RP
(remove nothere from the email address if mailing direct)