Groups > microsoft.public.excel.programming > #108197

Re: Can this code be optimized?

From	GS <gs@v.invalid>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Can this code be optimized?
Date	2015-11-25 19:46 -0500
Organization	A noiseless patient Spider
Message-ID	<n35kl7$7kh$1@dont-email.me> (permalink)
References	(2 earlier) <-aOdnckyPcfGn8vLnZ2dnUVZ5s6dnZ2d@giganews.com> <n35007$tts$6@dont-email.me> <hO-dnTSRZZblk8vLnZ2dnUVZ5qWdnZ2d@giganews.com> <n354ip$8tc$1@dont-email.me> <8ZGdnVK7Vfay3MvLnZ2dnUVZ5tidnZ2d@giganews.com>

Show all headers | View raw

> Hi Claus.  Indeed this improves the code that I originally
> posted, but in reality I will not be writing the same number "1"
> to each workbook at cell A1.  Assume that a random number
> will be written to A1 during each iteration of the loop.
>
> Also, the outer For-Next loop will run as high as 1 to 100,
> not 1 to 5.
>
> I aplogize for posting a streamlined version of the code.  I
> was hoping to keep my code simple.  I didn't think it was
> necessary to post ALL of the details, but I should have
> mentioned the part about the random numbers.
>
> Also, I thought maybe Excel 2013 was the source of the
> somewhat slower run time.

Robert,
How are you generating the random numbers, and what is their purpose?

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Thread

Can this code be optimized? "Robert Crandal" <noreply2me@yahoo.com> - 2015-11-25 04:30 -0700
  Re: Can this code be optimized? Claus Busch <claus_busch@t-online.de> - 2015-11-25 14:09 +0100
  Re: Can this code be optimized? witek <witek7205@gazeta.pl.invalid> - 2015-11-25 09:32 -0600
    Re: Can this code be optimized? "Robert Crandal" <noreply2me@yahoo.com> - 2015-11-25 11:47 -0700
      Re: Can this code be optimized? witek <witek7205@gazeta.pl.invalid> - 2015-11-25 12:54 -0600
        Re: Can this code be optimized? "Robert Crandal" <noreply2me@yahoo.com> - 2015-11-25 12:39 -0700
          Re: Can this code be optimized? Claus Busch <claus_busch@t-online.de> - 2015-11-25 21:12 +0100
            Re: Can this code be optimized? "Robert Crandal" <noreply2me@yahoo.com> - 2015-11-25 16:15 -0700
              Re: Can this code be optimized? GS <gs@v.invalid> - 2015-11-25 19:46 -0500
                Re: Can this code be optimized? "Robert Crandal" <noreply2me@yahoo.com> - 2015-11-25 18:51 -0700
                Re: Can this code be optimized? GS <gs@v.invalid> - 2015-11-25 22:07 -0500
                Re: Can this code be optimized? "Robert Crandal" <noreply2me@yahoo.com> - 2015-12-11 03:59 -0700
                Re: Can this code be optimized? Claus Busch <claus_busch@t-online.de> - 2015-11-26 09:48 +0100

csiph-web