How do I check cells using index in Add-In

[Guest]

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]

workbooks("filename.xls").worksheets("sheet1").range("a10")
or
workbooks("filename.xls").worksheets("sheet1").cells(10,1)



should work.

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

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