Name a Sheet as Text in Sheet 1 "M2"

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

Guest

I was looking for someone who could help me with the following. I wanted to
make a macro that at one point inserts a new sheet in the document and names
it after the content of cell M2 in sheet 1. Thanks in advance!
 
The best way for you to learn how to do this is to record a macro while you
do it.
 
Worksheets.Add.Name = Worksheets("Sheet1").Range("M2").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Get Name of Sheet to use in Macro 11
Modify Code to work on Sheets with different names 5
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Formula to consolidate 130 sheets into a summary sheet 6
Figuring out a lengthy formula. Probably quite simple... 3
moving rows to another sheet 3
hlookup with the sheet name is a reference from another cell 2
Auto Sheet Names and Date cells 3

Back
Top