how do i write a macro

[ab]

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

 

[Dave F]

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