Insert Formula into empty cell

Hello everyone,

I am trying to build a failsafe, in case that a formula is being deleted.

When I am using the following code, it works perfectly:

Please Login or Register  to view this content.

If I try to replace the formula with a more demanding one, doing a xlookup, I get a run-time error 1004:
Application-defined or object-defined error.

I tried the following:

Please Login or Register  to view this content.

could the two "" in the formula cause a problem? I also tried to put the formula itself into a variable to copy to destination
but that also did not work.

Maybe you know, where I am making a mistake?

It would be a nice to have

Thank you very much for the hellp,

Mike

Hi there,

Knee-jerk and untested suggestion - try:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

Hello Greg,

Thanx for helping but unfortunately not...

If we won't figure it out, I have also Plan B,

I just hide the first row with all the formulas and continue at row 2, that works for me... figured it out after I sent the question
but there might is someone out there, who needs a challenge

Thanx a lot,

Much appreciated

As well as the """" needed, it looks like you're using a ; to delimit the arguments.
On my machine Xlookup arguments are delimited by a comma.

Please Login or Register  to view this content.

yes, that is correct but it depends in which country/region you are. And as soon as there are dates, it becomes even more complicated

but as you saw correctly, I have to use the semicolon for my code and not commas

Are you able to successfully add the formula manually?
Are the references, clientdata[clientNr] etc, all valid?

Yes they are, because I use them successfully but wanted a backup in case that someone by mistake is deleting the formula, so I can implement them again.

Hmm I don't know then. Those were the only things giving me the 1004.

For me

Please Login or Register  to view this content.

works.

don't worry, I have a Plan B, and I appreciate the help !