tidy up code produced by macro recorder

[ADAMC]

Hi i was wondering if someone can help me tidy up and speed up some code i have recorded using the macro recorder VBE is not my strong point...I just know it could probably be better!

Many thanks for the help

Please Login or Register  to view this content.

[davesexcel]

Hi there,
I am not sure what you are trying to do with this code,
which columns do you want hidden
Here's a simpler way to hide columns

Please Login or Register  to view this content.

[royUK]

If you look at your code you can see that it selects ranges 7 does nothing so those lines can be deleted. Also, Auto_Open macros have been replaced with the Workbok_Open event. I think this does what you intended

Please Login or Register  to view this content.

[ADAMC]

Roy,

Thanks for the reply, i knew there were unwanted things in there i jsut didnt know which bits to take out but your solution worked for me.

Many thanks!!

[royUK]

You can always check by remming (precede them with an apostrophe) out lines that you suspect as unnecessary