My lastcell and my last used row of data does not coincide.
How do I set my last cell to coincide with the last cell of actual data.
Column B has data in every row except row 1. None of the other columns have contiguous data from row 2 onwards.
There is no row including row 1 that is empty.
The data columns run up to column M
I have this code that I adapted from elsewhere but it does not seem to work - at least not consistently.
Please help
--Perry
Please Login or Register to view this content.
Now sure why are clearing cells outside the used range, but ok, I typically do something like this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Your code seems to delete rows where column B is blank, down to 500. I don't know the reason for the problem you are experiencing... is it possible that the "used range" is below that 500 mark? The code below finds the last used row in column B, and then deletes the next row, down to row 100000... see if that helps.
Edit: I see now that JBeaucaire beat me to the same idea....Please Login or Register to view this content.
Last edited by Arkadi; 10-24-2016 at 10:56 AM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks