Sort Index without Inserting

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

RHurlburt

Thread Starter
Joined
Oct 31, 2003
Messages
130
The answer may already be here but I couldn't find it.
I am adding data to an index and then sorting. The sort routine will insert a row when the data needs to be moved up. I have other tables and information on the same sheet and when this sort occurs, the inserted row causes the information to be split.

My code to sort is:
***
Rows("6:" & [EnterSymbol].Rows.Count + 3).Sort Key1:=Range("B6"), Order1:=xlAscending
Application.ScreenUpdating = True

***

Is there something I can add to this code to prevent insert? Or do I just have to live with it and try to relocate all the data on the sheet?

Thanks
I should add that each cell item (symbol in this case) is related to the adjacent cell. ie B6, C6 must be kept together on the sort. The code above does what I need except it inserts when a new symbol falls within the already established index range.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top