Question about tidying up a macro to remove all slow down bits

Afternoon happy campers,

I am working on a sheet at present and so far my code includes LOTS of Range.Select, a sample taken from it is as follows:

Please Login or Register  to view this content.

Essentially i am recording a macro that will be saved into my personal workbook (to open every time i open excel) and the macro will be used each monday to copy the formulas into the sheet relevant to the week.
Although the macro doesnt run incredibly slow, i wanted to know if having all the .select bits could be removed to streamline the coding.

Many thanks in advance.

Yes, you can use

Please Login or Register  to view this content.

Ok thanks for that, the next question then would be;

How can i change that on mass, i mean there is almost 100 lines of that code

so current layout is

Please Login or Register  to view this content.

And i want to change it to

Please Login or Register  to view this content.

Regards

That's a little bit more complicated.... I guess you would need to do a find and replace for select & new line & activecell. but I don't know how/if that is possible.

ok not to worry, thank you very much anyway :D