Hi Paul,

I can't thank you enough!
I have never heard of the ghost feature before.

Some serious coding here,although it's way too advanced for me at the moment to understand, I can appreciate the complexity.

I have been trying to solve this problem for the past week unsuccessfully, so its really generous of you to solve this problem.

The code looks smashing.

In case I need to check the hidden columns I change the array numbers and the hidden set becomes visible - I tried that and so far it seems OK.

I hope you don't mind me asking - am I able to change the font size in the main Visible columns? Its a size 12 at the moment - If I can make the font bigger it would be easy on the eyes. If not no worries. I can do it manually.

For hidden text - the font size you have coded below - i can easily change that - thank you.


With Sty
With .Font

.Hidden = bHidden
.Size = 12


Again I thank you very much for your generous time and coding skills in helping me!


J