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