tidying up code

I am going to have a go at re writing some code I wrote a couple of years ago (with a lot of help from you guys), implementing some of the things I have learnt and with the intention of reducing the size of the code and making it more efficient.
Can you please help with a few starters, all of these work but I am sure there is a better way of acheiving the same thing:

1) copying and inserting columns

Please Login or Register  to view this content.

2) deleting various columns

Please Login or Register  to view this content.

3) deleting selected columns

Please Login or Register  to view this content.

Finally I frequently use the line:

Please Login or Register  to view this content.

Is there an advantage (or disadvantage) in using the .value as it appears to work without it

Thanks in advance

Hi,

Code #1. Something seems missing since you are copying column R but not pasting it anywhere. No need to use .Select
Shortened version:

Please Login or Register  to view this content.

Code #2. Again no need to use .Select:

Please Login or Register  to view this content.

Code #3. .Value can be used or not depending on the situation (e.g. when you you want the result of a formula rather the contents of the cell itself which is the forumla.

Hope this helps.

abousetta

Hi @tryer, glad I could help and thanks for marking the thread as Solved.

Good luck.

abousetta