Name a Sheet as Text in Sheet 1 "M2"

J

Jasper

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!
 
D

Don Guillett

The best way for you to learn how to do this is to record a macro while you
do it.
 
B

Bob Phillips

Worksheets.Add.Name = Worksheets("Sheet1").Range("M2").Value

--

HTH

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