Reduce rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
you can't delete rows (you may hide them). For your calculation you may
shrink the range in your formulas
 
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
Click to expand...
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.
 
Back
Top