Script doesn't work anymore (auto hide rows and columns

Hi Everyone,

I have a script which automaticly hide certain rows and columns, depending on a value, that value references back to a table.
It used to work fine, when i edited one of the numbers myself.

This is the code:

Please Login or Register  to view this content.

Now what i want, is to past a form in this sheet (which comes in by email) so i don't have to type anything anymore manually.
So in cell C1 i created an If-statement, and it looks like this:

Please Login or Register  to view this content.

So, when i past the form, C52 is been filled in, and in Cell D1 a number appears (and this still works fine, as you can see in the script numbers 1,2,3,4,5 stand for hiding certain columns and rows) It still searches the right number in a database, but it doesn't perform the script no more.

Maybe a helpful point:
C1 was originally formatted as a text-field, but because i use a formula now, i had to change it to a regular format. But this doesn't seem to affect the vlookup in D1.

I hope someone can help me, if it's unclear let me know.

Regards,

Bump no reply

Bump no reply