LinkBack URL
About LinkBacks
getting the error from here
Please Login or Register to view this content.Please Login or Register to view this content.
getting the error from herePlease Login or Register to view this content.Please Login or Register to view this content.
What does your entire code look like?
a lil messy..
Please Login or Register to view this content.
It could it be because GradSerial isn't being found.
What's in the range BoardRNG?
Is it dates formatted as YYMMYY?
If posting code please use code tags, see here.
Serial Month First Last
201310 Oct-13 1-Oct-13 31-Oct-13
201311 Nov-13 1-Nov-13 30-Nov-13
201312 Dec-13 1-Dec-13 31-Dec-13
20141 Jan-14 1-Jan-14 31-Jan-14
20142 Feb-14 1-Feb-14 28-Feb-14
looks like that. not formatted as YYMMYY I think.
That should have been YYYM, don't know where YYMMYY came from.
Anyway, the important thing is what's actually in column A.
Is it a date value formatted as YYYM, or is it a text value?
The code you posted is looking for a text value, not a date.
the value in column A, "201310" is a text.
I used Concat to merge the year and month together, 2013 + october
The problem could still be that GradSerial isn't being found.
Have you tried putting in the other arguments of Find eg After, LookAt, LookIn etc?
If you don't include those then VBA uses the same settings as were used in the last search.
thx for the tip! ill try again tmr.. gonna head to bed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks