Auto Unhidin columns

[ludzik]

The macro is opening all excel files in the folder, refresh them and save. Some of files have hidden columns. In row 1 there are dates like: A1: 2015-01 ; B1: 2015-02 ; C1: 2015-03... The column should be hidden if the row 2 has no value, so this should be hidden:
H1: 2015-08
H2:

and this should be unhidden:
G1: 2015-07
G2: 454578778


How to write code which will be hidding and unhiding columns according to this rule?

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values can be altered to suit any future worksheet changes.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[JasperD]

Please Login or Register  to view this content.

[Greg M]

Hi again,

Many thanks for the Reputation increase - much appreciated

Best regards,

Greg M