It looks like this code
http://www.vbaexpress.com/kb/getarticle.php?kb_id=479
is exactly what I need to sort my list alphabetically, but I don't know how to customize it to work with my project. I have an offset dynamic named range (1 column, starting with row 358). The name of that list is NAMES. (Some fake data is there for demonstration). So I understand I need to replace MyData with Names in this kbase code...but I do not understand how else to make it work. Especially the If Not Intersect part...it defined NMS as referring to something on a totally different sheet, which I didn't tell it to do...Deleting it brings the accursed "End If without Block If" error.
Meanwhile, can someone please diagnose my non-cooperative code ? I marked it solved too soon...
http://www.vbaexpress.com/forum/show...t=27942&page=2