That did it, thanks a lot.

"Bart" wrote:

Hello,

Im working on a standard excel sheet wich is going to be used in many
projects. Because of this de row count can vary.
I have to do sort functions in these rows, therefor i made a macro and
copied this macro under a commandbutton. This works perfectly. BUT how can I
make something like this with a variable row count???

Thanks in advance....