see http://www.vbaexpress.com/forum/showthread.php?p=25053
my call
- too often people attach data to the top or bottom of a range name and it doesn't get picked up.
- People seem to like creating range names and then use OFFSET to reference cells from that range. Not pretty from an auditing viewpoint. An Index/Match combination is better
Cheers
Dave