Selecting cell in VBA AND sorting

[ActSciMan]

Hello all, I have 2 questions, which are both probably extremely easy for you experienced users. Any help would be much appreciated.

1. Why does something like

Worksheets("Sheet1").Range("B1").Select

not work? Is the only way to accomplish this to do

Worksheets("Sheet1").Select
Range("B1").Select

???

2. As far as sorting, starting in Excel 2007, you can sort with up to 255 sort fields, right? I noticed that selecting some range and doing .Sort and then typing in Key1:= and Key2:= and Key3:= works, but only up to 3 sort fields can be used in this way. Why is that? I have found an alternative (from recording a macro). Is this the only way? It would be doing something like

With ActiveWorkbook.Worksheets("sheet1").Sort
  .SortFields.Clear
  .SortFields.Add Key:=Range("B1") 
  and add more keys as you need, then later
  .SetRange Range("A1:X30")             ' or whatever
  .Apply
End With

That is, using that method, you can add more than 3 keys and it works just fine.

Also, regarding this question, my number of rows might change from time to time and I don't want to have to redo the code each time. Can I use

.SetRange UsedRange

to get all my data in there?

Thanks!

[westconn1]

.SetRange UsedRange

did you try it?

[ActSciMan]

did you try it?

No, I didn't. My code is all at work. I'll probably try it when I get there. But, there was nothing wrong with asking just in case. For example, if it doesn't work and you happen to know that, then you could tell me a way that would work, if you happen to know that.