After clearing out cells at the bottom of a spreadsheet, in Excel 2000, I used to be able to Select those rows to the end of the sheet and Delete Rows to reset my range to the current used area. Seems with Excel 2007, this doesn't work any more. If I hit CNTRL SHFT END, I go down to row 30 no matter how many times I delete those rows.
I know there are macros that can reset but is there any other ways to reset the range?
Last edited by ChemistB; 03-23-2011 at 10:06 AM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Have you tried saving the file post row removal ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
My experience with 2003 and 2007 is that after you delete those rows, you have to save and close the workbook, then reopen it before the range is updated.
Duh, boy do I feel stupid. I've always used VBA but was working up some material for a training class for people without VBA and couldn't figure it out.
Thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks