Hello,
I've got a very quick question!
I've got the following code, (working perfectly):
The codes works very well and generates the sheet correctly..
Please Login or Register to view this content.
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
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
How about replacing all of that with:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
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?
If you create a sheet it's an empty sheet.
Referring to an empty cell doesn't make much sense:
referring to an existing sheet containing a value in B5Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks