Hi,

I get Error 1004 all the time and i don´t know what´s wrong.

My goal is to get the position of the last text in a column.

Worksheets("Transaktioner").Range("A1").FormulaR1C 1 =
"=IF(ISERROR(CELL(""address"";INDEX(Transaktioner! K:K;MATCH(REPT(""z"";
255);Transaktioner!K:K;1);1)));0;CELL(""address""; INDEX(Transaktioner!
K:K;MATCH(REPT(""z"";255);Transaktioner!K:K;1);1)) )"

The formula works when i paste it to my sheet. And i have replaced the
single " with "".

My first post here. I hope some kind person can help me.

Christheburg