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
|