Hi Guys Struggling on this one. I need to use WorksheetFunction.Countif in VBA to access info in another workbook but I cant get it to work.
My Code is:
t = Application.WorksheetFunction.CountIf('C:\My Directory\[Stock.xlsm]Main Stock'!$B$B, "<>")
Thanks in Advance

My Code is:
t = Application.WorksheetFunction.CountIf('C:\My Directory\[Stock.xlsm]Main Stock'!$B$B, "<>")
Thanks in Advance

Last edited: