I'm trying to sort tables of data according to the name of the range the
tables cover. Each table is exactly the same size (i.e. B2:M15) and
each range is named according to the name of the employee the table
relates to (e.g.SmithJohn for John Smith).

Each table has has an empty row above and below it, i.e. the upper left
corner of the first table is in B2, the upper left corner of the second
table is in B16, then B30...etc.

How can I sort these tables into alphabetical order according to the
name of the ranges they cover?

I need to do this in vba and I should point out that I'm only a novice
user!


---
Message posted from http://www.ExcelForum.com/