ExcelBanter - What's wrong ?

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

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

- - What's wrong ? (https://www.excelbanter.com/excel-programming/382288-whats-wrong.html)

Marijan Glavac

What's wrong ?

Workbooks(NazivNovogLista).Worksheets("Specifikaci ja").Cells(PozicijaNaNovomList,k)=_
Workbooks(NazivOtvoreneDatoteke).Worksheets("Podac i").Cells(PozicijaNaListuKataloga,i)

This was working fine in Excel 2003. But In Excel 2007 I recived
message error :
Run time error 9
Subscript out of range

Please help .

Marijan Glavac

What's wrong ?

I found what is wrong !
When I saved excel file get extension .xlsx. My
NazivNovogLista="Smece.xls"

All times are GMT +1. The time now is 08:13 AM.