Reduce rows

[Alby]

Hi all

How do I reduce the number of rows on my spreadsheet

The reason being is that for convenience, I do a number of sorting tasks and sort the whole column. My spreadsheet is 12000 rows deep, but when I calculate by a column ( say delete duplicates ) it takes forever, as it attempts to calculate rows 12001 to 65000, which hasn't and never will have any data

I would like the last row of my spreadsheet to be row 12000

Any ideas

Thank

Alby

 

[Frank Kabel]

Hi
you can't delete rows (you may hide them). For your calculation you may
shrink the range in your formulas

 

[tal]

I don't know how to tell the spreadsheet that it's last
row is 12000, but you can tell the sort function to sort
only the range you want (row 1 to 12000).

Private Sub CommandButton1_Click()
Range("A1:C12000").Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

-----Original Message-----
Hi all,

How do I reduce the number of rows on my spreadsheet?

The reason being is that for convenience, I do a number

of sorting tasks and sort the whole column. My spreadsheet
is 12000 rows deep, but when I calculate by a column ( say
delete duplicates ) it takes forever, as it attempts to
calculate rows 12001 to 65000, which hasn't and never will
have any data.