I like to use the following. SpecialCells limits itself to the UsedRange of
On Error Resume Next ' In case there are no blanks
William E. Hall wrote in message ...
>I have a spreadsheet with approximately 6000 rows. Somewhere around 40%
>of the rows are blank. I would like to develop a macro to delete the
>blank rows and retain the ones with numbers/text. I'm very new to the
>idea of macros (other than those that can be recorded), though it strikes
>me that something as simple as what I'm trying to do should
>be--well--simple to set up. Any ideas on where I can start?
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.