Way To Automate Naming a Tab - Code Edit

[b0ttle]

Hey guys,

Currently the code I am using asks a user to name each tab that they create, however the begin part of the code numbers off a column with week numbers,

Is there any way to have each time I click the macro button, rename the week to appropriate week that the macro produces in the column? rather than having to ask the user to input it manually?

Please Login or Register  to view this content.

[ranman256]

Please Login or Register  to view this content.

(BTW: wouldnt you name the range variable 'rng' (not wk) so you dont confuse it with a worksheet?)

[b0ttle]

The main issue im having is that I cant seem to get the x value to be entered, even with the code

And I could change the wk's all around, however this particular code has been very finaky so once I got it working I more or less left it

[b0ttle]

Bump,

Anyone have any ideas?