When using the following code:
[K6].Formula = _
"=VERGELIJKEN(J6,'Basiskalk.'!B:B,0)"
the formula is pasted as: =VERGELIJKEN(J6,Basiskalk.!B:B,0)
How to get the ' pasted as well?
When using the following code:
[K6].Formula = _
"=VERGELIJKEN(J6,'Basiskalk.'!B:B,0)"
the formula is pasted as: =VERGELIJKEN(J6,Basiskalk.!B:B,0)
How to get the ' pasted as well?
If I understood you correctly, as far as I know, the single quotation mark ' is used to reference the sheet name in the formula when your referenced sheet name consists of multiple words (more than one word) or one word with leading or trailing spaces in the sheet name.
So if your sheet name consists of a single word without any extra space and you use a single quotation mark in the formula, the formula will auto correct it and remove the single quotation mark since it is unnecessary.
You may try this on your sheet by manually writing the formula in K6 once with quotation marks and once with without quotation marks and you will find the formula in the cell without quotation marks.
Does this help?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
after giving an Enter it indeed worked. Solution is simpler than I thought.
Use the following code now:
[K6].FormulaR1C1 = "=MATCH(RC[-1],Basiskalk.!C[-9],0)"
Then it works straight away
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks