Single space? - help

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Sorry if this is dumb - I am new to this.

I have a large spreadsheet
About 10,000 rows x 20 columns.

Problem is it is every other row is blank.

How do I get rid of (re-format?) the spreadsheet to get
rid of the empty rows?

Example - all even rows are populated, all odd are
absolutely blank.
Now when I write formulas and apply to the whole
spreadsheet - I get zeros and errors in the empty rows!
(Not to mention, when it comes time to print it'll take
twice as much paper)

Thanking all the smart ones ahead of time ;-)
 
Select the entire range of data in one of the columns that has data in every other row. Do Edit /
Go To / Special / Blanks, then hit Edit / Delete Entire Row.
 
programmatically
(assumes column A represents the blank rows)

Workbooks("Book1.xls").Worksheets("Sheet1"). _
Columns(1).SpecialCells(xlBlanks). _
EntireRow.Delete xlShiftUp
 
Ohh!

Works! many thanks

Adam
-----Original Message-----
programmatically
(assumes column A represents the blank rows)

Workbooks("Book1.xls").Worksheets("Sheet1"). _
Columns(1).SpecialCells(xlBlanks). _
EntireRow.Delete xlShiftUp

--
Bob Kilmer




.
Click to expand...
 
Back
Top