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

aWS.Range("A18").Value =
s("T &
aWS.Range("A16").Value & ").Value

tytyvm
paolo

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 = _
("Sheet1") _
.Cells(aWS.Range("A16").Value, "T").Value


--
Regards,

OssieMac


"pls123" wrote:

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

aWS.Range("A18").Value =
s("T &
aWS.Range("A16").Value & ").Value

tytyvm
paolo

I FOUND !!
...SORRY ALL


"pls123" wrote:

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

aWS.Range("A18").Value =
s("T &
aWS.Range("A16").Value & ").Value

tytyvm
paolo