You are correct. Using that substitute function for usedrange is working perfectly though. Once I am finished I will be able to delete all the rows if I wish as another option.
On Thu, Apr 19, 2012 at 12:00 PM, Asa Rossoff <a...@lovetour.info> wrote: > I don't think Empty will have any more effect than ClearContents... > .UsedRange=Empty means .UsedRange.Value=Empty -- it is only clearing > values, same as ClearContents. .Delete removes the range from .UsedRange > entirely. > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Domain Admin > Sent: Thursday, April 19, 2012 11:34 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ What is left behind when you clear or delete > cell contents that still affects usedrange? > > 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 > > -- > 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
