Try this to make your UsedRange very clear
ActiveSheet.UsedRange=Empty Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of tangledweb Sent: Apr/Thu/2012 04:31 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange? I am doing many tests on columns of date pasted into a sheet. Sometimes more rows, sometimes less. It is important that I be able to define the working range as just what has data in it. However when I use clear or delete on the usedrange or currentregion or any other way to define it everything seems to be gone but there is something left behind that is part of usedrange. The only way I have found to make this work is to delete the entire row which deletes other stuff I want to keep. Is there really no way to truly empty the cells? Side not the ROUND function running on those cells puts in a 0 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
