ExcelBanter - Referencing a general Cell(i,j) in an Add-In

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Referencing a general Cell(i,j) in an Add-In (https://www.excelbanter.com/excel-programming/316122-referencing-general-cell-i-j-add.html)

Damo

Referencing a general Cell(i,j) in an Add-In

Hey guys.

I am wanting to reference cells in an add in. I can do it using an exact
range command of Applicatin.Range("'[File]Sheet'!$a$10").value, but how do I
do this if I need to use a Cell(i,j) type reference?

thanks
Damian

Dave Peterson[_4_]

Referencing a general Cell(i,j) in an Add-In

See the previous message.

Damo wrote:

Hey guys.

I am wanting to reference cells in an add in. I can do it using an exact
range command of Applicatin.Range("'[File]Sheet'!$a$10").value, but how do I
do this if I need to use a Cell(i,j) type reference?

thanks
Damian

--

Dave Peterson

All times are GMT +1. The time now is 05:31 AM.