Have you looked at the functions UBOUND and LBOUND? Do they work for you?

"ab" wrote:

I want to write a macro to sort uppper and lower bounds form a sries of data
(numerical).