View Single Post
 
Old 11-03-2015, 03:00 PM
jc491's Avatar
jc491 jc491 is offline Windows 7 64bit Office 2013
VBA Novice
 
Join Date: Sep 2015
Location: UK
Posts: 55
jc491 is on a distinguished road
Default

Hi Paul,

thanks for your reply.

Yes even I'm getting confused

Columns

1,3,4,6,7,9,10,12,13,15
Font Size 2
· Font Color White
· Border Color White
· Column Width = 20px


Columns - Normal Text Columns

2,5,8,11,14

Font Size 12
· Font Color - Black
· Border Color Dark Grey
· Column Width = 150px

There may be a few tables with up to 15 columns but majority will be around 12 columns or less

The reason they need to be formatted - as you can imagine the page cant hold that many columns - not enough space for comfortable editing.
So I need to hide some Columns to make space for easier editing reading etc.

I am unable to understand how to combine 2 macros to achieve my goal
J
Reply With Quote