Hiding columns using VBA

[marcus.brown]

Hi,

I am trying to hide columns using a macro, but it doesn't seem to be working properly.

The code I'm using is as follows.

Columns("JLT:MFS").Select
Range("JLT2").Activate
Selection.EntireColumn.Hidden = True

I'm not sure how relevant it is, but some cells are merged - JLT1:MOM1 is merged to 1 cell. When I run the code, the macro hides all the columns from JLT to MOM (inclusive).

I have more columns like the above which need to be hidden, and I encounter the same problem.

Please can you help.

Thanks

 

[chrisguk]

try this:

Columns("JLT:MFS").Select
Selection.EntireColumn.Hidden = True

Just to add to that. You will have to unmerge the columns first unfortunately

 

[marcus.brown]

Nope, that doesn't work - still the same problem.

 

[marcus.brown]

unmerge?!?? *@&*%$!!!! Sorry, but that just isn't a feasible option - it's tabulated data and by unmerging the cells, it becomes impossible to read - due to the sheer size of it.

Is there no way around it (other than manually doing this, which would take about 10+ hours, due to how slow the machine is running).

 

[VoG]

Try this http://www.mrexcel.com/forum/showthread.php?t=335123