Posts by Khwaja

I am sorry I missed the last tip. It is all good. Many thanks for your kind help.

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.

Range("G1").FormulaR1C1 = "Work Type ID"
    Range("G2").Formula = "=IF(AND(WEEKDAY(C3)< 7, WEEKDAY(C3)> 1),'CStd',IF(WEEKDAY(C3)=7,'CSat','CSun'))"
    Range("G2:G" & Range("F" & Rows.Count).End(xlUp).Row).FillDown