Consulting

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 1 to 20 of 122

Thread: Range Names : Good or Bad programming practice?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-04-2005, 07:18 PM #1
    brettdj
    brettdj is offline
    Knowledge Base Approver VBAX Expert brettdj's Avatar
    Joined
    May 2004
    Location
    Melbourne
    Posts
    649
    Location

    Range Names : Good or Bad modelling practice?

    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
    Last edited by brettdj; 05-05-2005 at 05:05 PM. Reason: misleading title
    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