the rigt syntaz

[pls123]

hi all can anybody show me the right syntax for this..

aWS.Range("A18").Value =
Workbook("@@@@PLT@@@@.xlsm").Sheets("Sheet1").Cells("T &
aWS.Range("A16").Value & ").Value

tytyvm
paolo

 

[OssieMac]

I am assuming that aWS.Range("A16").Value is supposed to be the row number.
If my assumption is correct then you need to realize that when you use the
Cells then the syntax is:- Cells(Row,Column) (the comma is also essential)

It is the reverse of Range("T8") where the column is first.

Note that the space and underscore at the end of the line is a line break in
an otherwise single line of code.

aWS.Range("A18").Value = _
Workbook("@@@@PLT@@@@.xlsm").Sheets("Sheet1") _
.Cells(aWS.Range("A16").Value, "T").Value

 

[pls123]

I FOUND !!
...SORRY ALL