Loop to Sort Columns

[hornbyOO]

Having a problem trying to do a simple loop to sort a number of individual columns A:K (though this is not a set number and I have a variable that stores the number of columns used) (Row 1 has headers).
The data in each column is independent of the others.

I have recorded a macro to see the structure of a simple sort but I am coming unstuck in two area 1stly getting the number of rows to sort on each loop and 2ndly with using R1C1 within the search code

Please Login or Register  to view this content.

I thought wrongly something like

Please Login or Register  to view this content.

But it doesn't like the syntax, and the row length is only 1. Any help much appreciated.

[Charles]

hi,

You have a ":" where you should have ",".

Please Login or Register  to view this content.

[hornbyOO]

Thanks for quick reply, I'm sure you're probably right but I can't check st the moment.
You wouldn't know how I can check a how many rows in each column as I loop through would you ?

Thanks again

[Charles]

hi,

Try this bit of code.

Please Login or Register  to view this content.

[hornbyOO]

hi,

You have a ":" where you should have ",".

Please Login or Register  to view this content.

Steps through to " .SetRange = Range(Cells(1, i), Cells(iRowLen, i))" and then fails with 'Runtime Error 438 Object doesn't support this property or method'


Thanks

[hornbyOO]

Didn't manage to sort the R1C1 problem in the sort routine, but took another path by highlighting the column data and using the following

Please Login or Register  to view this content.