+ Reply to Thread
Results 1 to 1 of 1

tidying up code and refering macros

  1. #1
    Registered User
    Join Date
    07-12-2005
    Posts
    21

    tidying up code and refering macros

    Hi all,

    I have created a macro and form to select roads that comply with certain conditions and then display the output, and select a random selection of that data.
    Within the form you can choose one of 13 inspectors and 1 of 10 days (Monday to friday week1 or week2).
    When the OK button is pressed it reads all the data in the spreadsheet cells. One of my buttons selects all inspectors and all days and prints the output. As my road list is 3000 roads, and it has to do this 130 times, it takes quite a while.
    What i want to do is read the data first time only, and for all subsequent times, use the data held in the vatrialbes, however i cannot use gosub, and if i use the call procedure i have to difine the variables, however there are too many for this.
    Is there a simpler way !!?!?!

    Please help
    I attach a very trimmed down version of the spreadsheet
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1