Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    a loop for various named ranges (excel 03)

    i have written some code which works with a combo box. there are threee choices in the combo box which change the decimal places on data schedules on two worksheets

    my code works great but i wanna learn how to make it more efficent with using a for next loop or something. attached is my code which works behind the combo box.

    code someone give me an example of how I can do this with a loop?

    Thanks

  2. #2
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a loop for various named ranges (excel 03)

    attached is my attempt which seem to be kinda close but incorrect.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: a loop for various named ranges (excel 03)

    There shouldn't be a line Exit For in there.

  4. #4
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a loop for various named ranges (excel 03)

    ok thanks i think i got the idea

Posting Permissions

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