as part of I Macro I am trying to paste a formula in a cell, but get an error.
[K6].Formula = _
"=VERGELIJKEN(J6;'Basiskalk.'!B:B;0)"
What am I doing wrong here? I tried to use COMPARE instead of VERGELIJKEN, but that didn't help me either.
as part of I Macro I am trying to paste a formula in a cell, but get an error.
[K6].Formula = _
"=VERGELIJKEN(J6;'Basiskalk.'!B:B;0)"
What am I doing wrong here? I tried to use COMPARE instead of VERGELIJKEN, but that didn't help me either.
As well as using COMPARE change the ; to ,.
If posting code please use code tags, see here.
thank's, it's excecuted now, but the ' ' are now removed. Tried with ", "" and variations, but don't get it to work properly yet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks