Never mind about the ROUND part. It returns 0 for a truly empty cell. On Wed, Apr 18, 2012 at 4:01 PM, tangledweb <domainqu...@gmail.com> wrote: > 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
