A macro contains this which works:
but using a variable for the year does not work:Please Login or Register to view this content.
Any suggestions?Please Login or Register to view this content.
A macro contains this which works:
but using a variable for the year does not work:Please Login or Register to view this content.
Any suggestions?Please Login or Register to view this content.
Last edited by DonkeyOte; 11-04-2010 at 03:35 AM. Reason: tags
TryPlease Login or Register to view this content.
First off - please always use CODE tags even for one liners.
Your quotations are slightly awry
It would also be better to use Application.InputBox so as to restrict entry to numbers (then conduct further tests to ensure valid/reasonable value)Please Login or Register to view this content.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks to Dave and you, DonkeyOte - all's well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks