How do I check cells using index in Add-In
 

I am having problems referencing cells in an Add-in sheet. Writing to and
from an exact reference is AOK using
Application.Range("'[Filename]Sheet'!$A$10").Value command, but how do I do
this if i would normally use something like Worksheets("Sheet1").Cells(i,j)
command?

Thanks in Advance

Damian Lee

How do I check cells using index in Add-In
 

workbooks("filename.xls").worksheets("sheet1").ran ge("a10")
or
workbooks("filename.xls").worksheets("sheet1").cel ls(10,1)



should work.

Note that you don't include the path in this.

Damo wrote:

I am having problems referencing cells in an Add-in sheet. Writing to and
from an exact reference is AOK using
Application.Range("'[Filename]Sheet'!$A$10").Value command, but how do I do
this if i would normally use something like Worksheets("Sheet1").Cells(i,j)
command?

Thanks in Advance

Damian Lee

--

Dave Peterson