Adding workbook to application.worksheetfuntion

[batjl9]

Hi guys

I have a code set up which works great and does exactly as I want it to, but now I am trying to expand it and I am struggling with the addition. The code is below. What I would like is an additional set of functions using another active workbook, as so far the code is only for the workbook it is located in.

Please Login or Register  to view this content.

I am assuming the addition of a workbook would go between application and worksheetfunction, but so far all of my attempts have failed.

If anyone could help out with this I would be really grateful.

Thanks
Gemma

[JBeaucaire]

You would be adding to the target address, I think. You're wanting to apply functions to do SUMIF and COUNTIF with data from another workbook, yes?

Please Login or Register  to view this content.

This presumes the other workbook is open. More code could be added to check if the other workbook is open or not and open it if needed.

[batjl9]

Wow I wasn't expecting a reply so quickly, thank you. I will get to work on it in a few hours when the girls go to bed and I have some peace and quiet!

Thanks again

Gemma

[BigBas]

Just to add, consider using the With End syntax to trim down your code. For example:

Please Login or Register  to view this content.

[batjl9]

The code works perfectly, thank you. I have also amended my codes trimming them down as you suggested.

Thanks again
Gemma