Tech Support Guy banner
Status
Not open for further replies.
1 - 1 of 1 Posts

· Registered
Joined
·
132 Posts
Discussion Starter · #1 ·
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.
 
1 - 1 of 1 Posts
Status
Not open for further replies.
Top