LinkBack URL
About LinkBacks
my spreadsheet has more than a million blank rows after the last non-blank row.
how can i eliminate those blank rows?
my spreadsheet has more than a million blank rows after the last non-blank row.
how can i eliminate those blank rows?
Last edited by Joe Miller; 06-03-2018 at 11:38 AM. Reason: edited link to cross post
Re: how can i eliminate blank rows that exist beyond the last non-bank row?
maybe try hide rows
hiderows.gif
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
''Click on the first blank, ctrl-shift-down arrow, hide the rows'' worked for me.
thanks all you guys, you are a great resource!
please let me know if it was me that cross posted? i don't think it was?
how do i mark this thread as ''answered''
Unless by coincidence somebody else with the same name as you asked the exact same question as you on another forum a few hours before you asked it here, then yes, it was definitely you.Originally Posted by Joe Miller
sorry about that... i have no idea how it happened?
how do i mark the thread solved?
Not something that can happen by accident, you would have to sign in (or create a profile if you didn't already have one there), start a new thread, type the question, and submit it.
That is quite a lot to do and not be aware of, especially as you have been back there and replied to the help provided several times.
The only reasonable assumption I can make is that you do not fully understand the meaning of cross posting. Please take a moment to read post #3, and the page that Ford has provided a link to there.
After doing so, please also take the time to edit your first post in this thread with a link to your cross post.
If that takes care of your original question, & to say Thanks and for better Motivation, pleaseIf you did it already - ignore it.
- click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then- select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
Thank you.
I suppose it IS possible that someone with the same name OR the same question posted on the other forum, but when BOTH match, that is a bit of a stretch.
It's not that it is prohibited, just that you are required to notify where else you may have posted (both ways), so members dont waste time answering something that may already have been answered elsewhere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks