Hello.
I would like to ask for help.I have worksheet where is about 30 sheet.
I need create marco which would change name of individual sheets (
indenpendently on sheet´s previous name ) according to date I put in some
form.
For example:
I have put date 23.10 to 28.10 (number of days = x)
I need macro to remame x sheets.In this case
sheets(1).name = 23.10
sheets(1)name = 24.10.......and so on untill 28.10.


Like this is not problem for me but I need the marco which would function
even the number of day would differ every time.
So there has to be used variant in the index of sheet and not
sheet(1),sheet(2)
but something as sheet (a +b)
Is something like this posibble?
Hopefully you understand what I want my english is not so good.
Thank you.