Excel Writecell does not accept a string cell reference

[george.muammar]

Hi,
Unfortunately, all the online documentation and examples seem to refer to an old version of writecell, which happily accepted a string reference e.g. “A1” to write to. This was too easy, apparently, so now we have to supply a parameter of type iReadWriteCellRef for which there is no documentation.
So when I try to give it a string I get an error BC30512 Option Strict On disallows implicit conversion from ‘String’ to ‘iReadWriteCellRef’.
Please help.
Thanks
George

[natanael.mendes]

which activity you using?

[Yoichi]

HI,

Can you try as the following?

 Excel.Sheet("Sheet1").Cell("A1")

Regards,

[george.muammar]

YOU ROCK! That’s it, it’s correct. I had played around in that direction, but not enough