Thanks but I can easily clear the entire sheet. What is needed is to be able to clear a set of columns except not the header row and then paste in new column data and have usedrange be just the number of rows with the new data. I will try to see if I can use empty on the columns.
On Thu, Apr 19, 2012 at 6:14 AM, Rajan_Verma <rajanverma1...@gmail.com> wrote: > 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 -- 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
