I am sorry I missed the last tip. It is all good. Many thanks for your kind help.
Posts by Khwaja
Thanks. good idea. The only difference was that I changed double quotes to single in the VB as I was getting compile error. To get this working back in Excel, I reverted it and it works there. So still no resolution.
As part of the long piece of code, at the end I have these 3 lines to add a formula and fill down. But for the life of me I cannot make it work. I keep receiving the error. Looks like that weekday function has an issue. But I do need to use this. Will appreciate some help.