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?
Thank youDim StockNum As Integer StockNum = Evaluate("=C:\[2015 COST SHEET.xls]COSTS'!H23") Range("E196").Value = StockNum
Bookmarks