ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with Range and Sorting Data (https://www.excelbanter.com/excel-discussion-misc-queries/149042-problem-range-sorting-data.html)

Elise148

Problem with Range and Sorting Data
 
I am trying to sort data. The area of the data will continually change, so I
defined a range name and was trying to use that to sort. My problem is that
the range expands itself when I run the macro. Earlier in the macro I find a
cell, copy it, and paste it to another section of the worksheet. My VBA code
for it is listed below...what am I doing wrong? ("IC" is the range name)

Range("A7").Select

Cells.Find(What:=InputBox("Enter Territory number you wish to search
for.", "Enter Territory Number."), After:=ActiveCell, LookIn:=xlValues,
LookAt:= _
xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext,
MatchCase:= _
False).Activate

ActiveCell.EntireRow.Select
Selection.Cut
Cells.Find(What:=InputBox("Enter a territory number of a distributor in
the IC grouping.")).Select

Selection.Insert Shift:=xlDown

Selection.Sort Key1:=Range("IC"), Order1:=xlAscending, Header:=xlGuess,
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Range("A7").Select



All times are GMT +1. The time now is 09:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com