'Evaluate' Error

[jonnyking]

Hi Guys,

Just trying to grab a cell from another workbook using Evaluate as i dont want the formula in the workbook cell only the result.

"Evaluate" i have been told is a very powerful function but it wont work for this... Is it possible?

Please Login or Register  to view this content.

Thank you

[walruseggman]

Just use .Value for the H23 cell the same way you use it for E196. No need to use evaluate if your description is accurate.

[Arkadi]

jonny, I think there is a syntax problem... you have a ' after the sheet name, but none before?

[Arkadi]

You can't use evaluate on closed workbooks.

Try:

Please Login or Register  to view this content.

This will get the value from the other book and then put the value that results into the cell

[jonnyking]

Sorry Arkadi that was a typo in my question. It still hits a debug error. (fixed in orig post)

Just use .Value for the H23 cell the same way you use it for E196. No need to use evaluate if your description is accurate.

It will then return with "=C:\[2015 COST SHEET.xls]COSTS'!H23" rather than the value I actually want. If I type "=C:\[2015 COST SHEET.xls]COSTS'!H23" in the cell it works so i'm sure there is a way for VBA to calculate that then give me the answer as plain text.

[Arkadi]

Yep... but see my last post just above yours... sorry, realized it after I'd already mentioned the syntax thing.

[jonnyking]

Yep... but see my last post just above yours... sorry, realized it after I'd already mentioned the syntax thing.

Ah! Thank you Arkadi. Thats the very basic part i could get working sorted. Now to get to the meat of the problem. Thank you again guys. I think I can sort it from here

[Arkadi]

Great Let us know if you need more help, and please mark the post as solved if you are satisfied.