This used to work for me and now it no longer works????

ran = Range(hExcel.ActiveSheet,XRangeAddress([1,1], 'A1'))

ran =

Interface.00020846_0000_0000_C000_000000000046

K>> ran.Value

Unrecognized function or variable 'Value'.

[dpb]

What is XRangeAddress? I can find no reference to such a method nor property in VBA documentation...I gather it must be a local function to build an address or somesuch? Whatever it is, it would appear the result while apparently an Excel object isn't a valid Range.

Why not just

 hExcel.ActiveSheet.Range('A1').Value

We'd have to see a complete working example to diagnose in detail