That one is exactly what i want,
The maximum amount of the worksheet it will be 50
Range will be like D5
50 (And a version of code if the range is particular like ; D25
40: D45
60)
I just want to continue in my current sheet (I don't want the new worksheet to be selected).
In the range D5
50 I will set up data validation so when i put a value in the cell
i want automatically the worksheet to be insert into the workbook.
Thank you once more for helping me to fix that.
Dritan