Auto naming worksheets
 

In a Macro-as I copy and rename a worksheet, can I auto name the new
worksheet as a user entry in one of the cells of the worksheet?

Auto naming worksheets
 

Once you copy that worksheet, the new worksheet becomes the activesheet.

So after the copy...

with activesheet
.name = .range("a1").value '.text ???
end with

(No validation on that cell!)

Kenny R wrote:

In a Macro-as I copy and rename a worksheet, can I auto name the new
worksheet as a user entry in one of the cells of the worksheet?

--

Dave Peterson