Hi,
I have sheet1 with names of staff and sheet2 with linkformulas to sheet1.
I want to hide or unhide columns in sheet2 wether there is values printed in the first sheet or not.

I assume there has to some ChangeVal code, but I can't solve this.

Any ideas?

//Thomas