Countif Value problem

[James580]

I have a code that opens another workbook and looks at some cells and then returns the values. The problem is F20 in the opening document has a countif and gives the value but when it comes back into the main file it has the formula and not the value

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is used by check boxes and then adds up all the check in F20

[DonkeyOte]

Are you saying you want to copy the value and not the formula ?

Please Login or Register  to view this content.

[James580]

Yes just the value

[jhp580]

Solved Thank you,

I tried to do the edit and Go Adv and solved but couldn't find it

[VBA Noob]

I assume you couldn't mark it as solved as you're signed in as a different user.

e.g James580 started the thread and you answered as jhp580.

I've marked it solved for you but if you're not one in the same person then James580 let me know.

VBA Noob