Problem using numerical reference to Excel object range

  • Thread starter Thread starter Keith
  • Start date Start date
K

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
 
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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem using Range objects 1
Excel VBA setting Ranges 2
Excel VBA 1
Code to name numerous ranges 11
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Count of Font Format 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Macro to use cells as a autofilter 0

Back
Top