System Year on Macro

[excelit]

Hello,

I've got a very quick question!

I've got the following code, (working perfectly):

Please Login or Register  to view this content.

The codes works very well and generates the sheet correctly..

Now what I want to do is... instead of having a box asking you to enter the current year, I want the macro to automatically take the year from the system date.

Im sure it doesnt require a big change in the code..(at least I think so!)

Any help would be appreciated!
Thanks

[shg]

Please Login or Register  to view this content.

[JBeaucaire]

How about replacing all of that with:

Please Login or Register  to view this content.

[excelit]

How do I link Yr to a cell instead? Instead of having Yr = Year (Date), can I just put:
Yr = worksheetname!B5 ?

If not, how do I link the year from a cell?

[snb]

If you create a sheet it's an empty sheet.
Referring to an empty cell doesn't make much sense:

Please Login or Register  to view this content.

referring to an existing sheet containing a value in B5

Please Login or Register  to view this content.