Why does macro work in one book and not another?

I have assistance in another thread writing a vba

HTML Code: 

. That vba was written and crafted to do exactly as requested, but i've run into an issue with running that vba on other worksheets. I have two sheets attached. The one titeld "does work" is what I was given from the aforementioned thread. The Does not work is what will be hereafter as that is what out program will generate.

I can't figure out what the differences are between the two workbooks.

I run my VBAs from PERSONAL.XLSB. So it is the same vba running each time.

Sorry if the Admins believe this is a continuation of the other thread, but that thread was answered and this is a separate issue and one that isn't tied to the previous specific vba.

no code in book that does not work


Cheers
Leo

Yes. Tested in Excel 2013 64bit.

Sorry, wasn't sure about using the previous's post macro and blend the posts, since I was pretty sure this was a workbook (or i'm a dummy) issue.

Please Login or Register  to view this content.

That seems to be working. So what is it? I see you have Private Function now, With .Cells(i, "H") has changed too. Either way, why would your macro work in your book but not others?

I gotcha. OK. That makes sense. I really appreciate it. I sent it over and tried it off a brand new report and it works great.


One last question if I may that was brought up when I sent it over. Is there a way to add in WORKDAY into the today()-f2? or whatever would account for holidays and weekends?

Correct! In the days since last payment.