View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Loomis Ken Loomis is offline
external usenet poster
 
Posts: 143
Default Sorting a single column

In some VBA code, I need to sort column A on a hidden sheet called
"OldFiles". Column A is the only column containing data, so that is all that
needs to be sorted.

Can I do that without selecting that column.

and, either way, what VBA would I use?

It needs to be sorted alphabetically in ascending order.

TIA,
Ken