View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean Dean is offline
external usenet poster
 
Posts: 93
Default Sort of a problem?

I have a range that is always changing in size. but I want to be able to sort
it!
I've tried recording a Macro to select the bottom, goto the top etc. but I
get an error "Application definded or Object definded error when running it
from a command button.

Can anyone suggest a peice of code to help me please.
The range always starts at A5 and is 8 columns wide but as I said I don't
know howmany rows as the data changes. I will always be needing to sort bu
Column E Descending.

Thanks
Dean