UsedRange Problem

I am having real trouble trying to get the UsedRange to report the correct used range; here is my code that formats the sheet:

Please Login or Register  to view this content.

After the sheet is formatted the used range includes cells/rows that are well outside of the actual used range and everytime I run it the used range rows increases despite the actual data remaining the same size?! I've hardcoded the Sheets("Detail") to prove the process.

Thanks DonkeyOte, problem solved now!