Running the macro recorder I got this:
Now I want the 2 YEARS to be able to change based on cell data... Or if it helps the 2 cells are just This Year and last year (ie. NOW() and NOW()-365 but formatted as custom = YYYY)Please Login or Register to view this content.
So I have this, but it seems to throw me an error everytime I try it:
The error I get now in Microsoft VB isPlease Login or Register to view this content.
Run-time error '1004':
Application-defined or object-defined error
I also tried changing
toPlease Login or Register to view this content.
after makingPlease Login or Register to view this content.
Please Login or Register to view this content.
I also tried
after setting D10 on sheet3 to =GetSQLString()Please Login or Register to view this content.
Thanks for your help!
Bookmarks