Error 2023 - triggered by variable - Cant find mistake

Hello!
Starting Point: I have a master sheet, where I can activate a new sheet with a checkbox that gets the name of a certain cell. Afterwards I want to switch back to the master sheet and insert some formulas containing the name of the new sheet. The problem is I get a 2023 error for the variables that I marked red in the following code. I know it is a reference error but I dont know how to fix it. I just want the macro to insert the formula instead of checking reference. The code that the variable produces is correct (I tested it) and does what I want it to do, but the macro does not insert it:

Please Login or Register  to view this content.

Thanks a lot,
Taktiker

I think the problem is that you are trying to do a worksheet calculation in a variable. Try putting these formulas in cells and then the result would be a variable, OR you can turn them into vba if statements and functions.

abousetta