the rigt syntaz
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
|