Forum Discussion
Solved
Why does my countifs vba returns 0 when the excel formula was previously populating the correct data
Why does my countifs vba returns 0 when the excel formula was previously populating the correct data? I am confused on where did it gone wrong. Sub CalculateCountifs()
Dim ws As Worksheet
...
OliverScheurich , thank you for assisting. I am looking up data from another workbook from a different file path.
Tried the code that you have provided; had came up with an error:
Run-time error '6' Overflow.Are you able to code in a way whereby data is look up from another workbook from a different file path?
HansVogelaar , sorry to bother you again, would you be able to help take a quick look how the code should be amended?
I'd have to see the workbooks involved.
- Went to take a relook at the data again and the code, restart the excel and everything seems to be populating the correct figures. thanks for the help again!