View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sugargenius sugargenius is offline
external usenet poster
 
Posts: 26
Default best way to get reference to all used cells

I was using the macro recorder to see how to use the range.sort
function. When I did, I got something like:

Range("A1:J235").Sort Key1:=Range("A1"), Order1:=xlAscending

I should always know the number of columns but the number of rows will
vary. What's the best in code of coming up the "A1:J235"?

Thanks,
Woody