Re: Delete a blank row on spreadsheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

Brad,

Take a look at Edit > Go To > Special > Blanks
(do this on a single column)

Than do a single Edit > Delete > Entire Row

Record a macro and see how this works.

Play with the code and eliminate all the selecting.

--
steveB

Remove "AYN" from email to respond
"Brad Zenner" <bzenner@xxxxxxxxx> wrote in message
news:BF13E338.10E8%bzenner@xxxxxxxxxxxx
> Hi all...my request for advice is a little different
>
> I have a spread*** with a large amount of rows of data in it, but the
> data
> is separated by a blank row in between different parts of the project.
> However the blank row is at a random point...Might be after 6 rows of
> data,
> then after 3 rows, then after 7 rows, etc. I'd like to delete those blank
> rows?
>
> Any help for the novice here?
> Thanks in advance
> Brad Zenner
>


.

Quantcast