Is it possible to do the following in Excel 2003?

1) Name columns so they can be referred to in VBA

2) Write VBA for sorting with named columns instead of the default column letters (could you show me a working sample?)