I'm trying to create a Macro in Excel to do what my Lotus macro would do for
me.

My Lotus macro did the following:

1) Goto to sheet A cell A1
2) It defined the data range to sort --- I had predefined data ranges which
were included in the Macro.
3) Selection of Primary key by moving over from cell A1 to the column that
contains the Primary key to sort by........ I would move 14 columns over.
4) Selection of Descending or Ascending and then execute

Can data ranges be defined within the Excel Macro?

I don't care if the macro does exactly what I was doing in Lotus so I'm open
to any suggestions.

I appreciate your help in advance!!!

Thanks
Carlos