Results 1 to 10 of 36

Thread: Distribute ranges as per Plan

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #34
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    14
    Hi,

    THe "Location" grid starts in column "F" thru "U". The way I had the code set was to go
    "F to "U" and if you added another column say "V" then the code will not work properly because I
    pre set the range to "U". In this copy I changed the code so that if you added more columns the code will see it
    and not fail. In column "F" you have the "Alpha" characters. If you add more to this the code should still work.
    It was the matter of extending the "Columns".
    I did not test for this, but you can and let me know.
    Attached Files Attached Files

Similar Threads

  1. Replies: 5
    Last Post: 05-28-2013, 03:00 AM
  2. Intersection of Overlapping Ranges:Space Operator
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  3. List all the name ranges in an excel sheet with scope
    By LalitPandey87 in forum Excel Help
    Replies: 4
    Last Post: 03-28-2012, 07:27 AM
  4. Delete Name Ranges by Scope VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 12-20-2011, 03:54 AM
  5. List Unique/Common Values From Two Ranges
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 09-16-2011, 08:34 AM

Posting Permissions

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