This may be better off as a poll, http://www.vbaexpress.com/forum/showthread.php?t=3083

1) Bad

- 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

2) No

follows (1)

Cheers

Dave