Hello and thanks for taking the time to read this....and hopefully provide some guidance
I'm very new to writing Macros and am trying to use the Vlookup - this first attempt is just a test to see if I can get it to work.
I have the range of A2:D367 named as: Useme
Column A is a list of dates, starting A2 = 1/1/2012 through A367 = 12/31/12
Column D lists the actual volume of transactions for that day.
The goal (for this test) is to pick a date and have Excel return the volume for that date.
Here is what I have:
If I omit the whole Vlookup part, the rest of the macro does correctly identify the proper row that holds the correct volume.
With the Vlookup part added, I get the Run Time Error '1004'
Any assistance would be greatly appreciated -
Thank you in advance,
Dan
Bookmarks