How to use offset function of excel vba in Matlab coding environment????

thanks!!!

first_m = objSheet.Range('A:Z').Find('month').offset(0,1).Address;

my 'month' is in cell A1, my target cell is A2, my code is listed below.

objExcel = actxserver('excel.application'); 
set(objExcel, 'Visible',1); 
sheetName = 'DPLLC'; 
objSheet = objExcel.Worksheets.get('Item', sheetName); 
first_m = objSheet.Range('A:Z').Find('month').offset(2,1).Address;

but give me error like ??? 'Subscript indices must either be real positive integers or logicals.'

[Fangjun Jiang]

Please include some of your code including the creation of the objSheet.

[Nan Shen]

Here you go! thank you!

my 'month' is in cell A1, my target cell is A2

objExcel = actxserver('excel.application');

set(objExcel, 'Visible',1);

sheetName = 'DPLLC';

objSheet = objExcel.Worksheets.get('Item', sheetName);

first_m = objSheet.Range('A:Z').Find('month').offset(2,1).Address;

Answer 1

[Sean de Wolski]

Matlab indexing starts at 1 not 0.

 first_m = objSheet.Range('A:Z').Find('month').offset(1,1).Address;

[Nan Shen]

my 'month' is in cell A1, I really want the address A2. as you remanding, I used first_m = objSheet.Range('A:Z').Find('month').offset(1,2).Address; but give me 'Index exceeds matrix dimensions.' how to deal with that?