View Poll Results: Should the use of Range Names be recommended as good modelling pratice?

Voters
51. You may not vote on this poll

  • No

    13 25.49%

  • Yes

    38 74.51%
Results 41 to 60 of 122

Thread: Range Names : Good or Bad programming practice?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-07-2005, 05:35 AM #11
    matthewspatrick
    matthewspatrick is offline
    VBAX Expert
    Joined
    Jul 2004
    Location
    Wilmington, DE
    Posts
    600
    Location
    Overall, named ranges are a Good Thing, but when misused they can be more trouble than they are worth.

    Something I am doing more and more often is using dynamic named ranges. That defeats the "what if they add/subtract data" problem. Of course, having too many dynmaic ranges can hurt performance. I also recently ran into a surprising problem with dynamic named ranges:

    http://www.experts-exchange.com/Appl..._21414425.html

    Patrick
    Last edited by matthewspatrick; 05-07-2005 at 05:35 AM. Reason: missed a word
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules