new worksheet and rename from cell contents macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I need a macro to:

Copy the latest worksheet, (not a specific one each time)
Rename the worksheet to the contents of a cell (i.e. a date)


Any help with code?
 
This should start you off in the right direction.
Tell me what you don't like about it and we will go from there.

Sub TryThis()

Sheets(Sheets.Count).Copy After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Sheets(Sheets.Count).Range("A1").Value

End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Worksheet Names using Macros 5
Rename Worksheet From Cell Data 6
Hide columns based on row values 2
Variable to rename a tab in a worksheet via VBA 5
Rename Sheet using Cell Reference 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Create new worksheet from template for each value in range 6

Back
Top