passing a range as a parameter

I've posted about a similar issue in the past but never really understood. I'm at the same roadblock again and I've tried to make it really simple, but I still can't get it to work.

Please Login or Register  to view this content.

Two things: I'd like for it to sort based on the first column of the range and it currently just errors out. I'm not sure what's wrong. Secondly, I don't like hardcoding in the number 23. It will always sort starting at Cell(1,1) but I'd like for it to automatically adjust to the end of column 1, e.g. Cells(1,X). Any help would be greatly appreciated.

Thanks. I'm still getting an error, but now it's in a different place so this is progress.

"Method 'Range' of object '_Global' failed" and it highlighted this line:

Range(rng).Sort Key1:=Range(Cells(1, 1), Cells(1, 23))

Originally Posted by shg

Did you look at the second half of the post?

Range(rng) is an invalid construct.

Range(Cells(1, 1), Cells(1, 23)) refers to A1:W1 on the active sheet, unrelated to the variable rng.

You edited your post and added the second part after I loaded the page and started typing my reply. Thank you though. It was exactly what I needed. I'm still learning the basics of VBA and I didn't think to reference rng like it is an object.