Default code for formatting in excel

Actually, we just copy few names from different places into a workbook. The problem is it copies the text in bold and also background color to the workbook.
The copied contents do start from A2 and may run into many rows.
I need the current workbook entirely set up to default with the following;
Default - Font Type - Times New Roman
Default - Proper case text
Default - Unbold Text
Default - No background color in cells.

Any help on this will highly be appreciated. Thanks in advance..

hi...alphafrog thanks for your speedy response, well i agree, this does the needful.... but there are other data filled in by others who don't follow this and the book is full of with formatted and colors........and I would appreciate if you can give me a code to default all this to the required..... thanks again in anticipation.......

Give this a go

Please Login or Register  to view this content.

This probably isn't the fastest way to achieve what you want, changing to Proper Case requires looping through all the cells with text values which slows things down a little.

If you insert this into a module if will work on whichever worksheet is active when you execute the macro.

USE WITH CAUTION, it is not possible to undo the effects of a macro, make sure you have a back-up copy of the file until you know that it is working as intended.

Yes...... thatandyward you got it exactly and it does exactly how I wanted it to be.......You have saved great time by giving me this code......Thank you so much.....God bless you......I will close this as solved and add reputation too........ .....This forum members really are Excel Maestros !!!