Mynda, Thanks for the alternative formula, but not sure it's needed. You said "and for dates 13 through 31st your formula returns an error" but it...
Still desiring some help.
BTW, it didn't come as a CSV or text file, just a vanilla Excel file.
I'm so sorry! I DID add an attachment with my original post, not sure where it went. Trying it again.
Thanks Phillip. I also thought that maybe the negative on xlMedium was throwing it off, but didn't understand why. Thanks for the CLng trick, I can ...
That raises a question; in my original macro, where I dimmed Thickness As a String, xlThin or xlThick worked fine. Why didn't they error, why was it ...
OMG, I don't think I ever would have considered it numeric. But you're absolutely right; changing it to a LONG makes all the difference. Thank you!