Problem using numerical reference to Excel object range

[Keith]

Hello

I have created an Excel Sheet object in an Access Module,
and now I need to reference the cells of a range. I find
that the following reference

myrange = ExcelSheet.Application.range("a1:c3").Value

works, but the numerical reference

myrange = ExcelSheet.Application.range(cells(1, 1), cells
(3, 3)).Value

does not work.

What have I done wrong? How can I use numerical references
to a cell range in this situation?

thank you,
Keith

 

[RobFMS]

One suggestion is to convert the Row/Column values to the Excel Cell values.
To do this, use the ADDRESS() function.

See the help file for more details.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[keith]

Hi Rob,
Thanks very much. I'll give it a try.
Keith