Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110498
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Performance lag issue |
| Date | 2018-02-14 06:31 -0500 |
| Organization | A noiseless patient Spider |
| Message-ID | <p616md$sgo$1@dont-email.me> (permalink) |
| References | <5c409591-c24f-4340-853f-951d681a5e40@googlegroups.com> <p5utvj$n02$1@dont-email.me> <p5vfag$no0$1@dont-email.me> <7c6a0a5a-1605-433c-81e9-6a760925015d@googlegroups.com> |
> Garry & Claus > > Thank you once again, you guys are amazing. > > Garry > > Not wanting you to feel your contribution wasn't appreciated, I "will" try > your idea later when I have time; I went with Claus'code as it was quick > which got me where I needed to be today. Enjoy! > > Claus > > As I have already captured the results of the original data rows in Columns > A:L which is the target region where Data will get updated to each week, is > there a way to skip the code so it doesn't always start at Row 2, rather > start at the first newly added data that has a blank cell in Column "M". > > BTW > > Code took roughly 60 secs to do just under 100k rows, very neat, thank you. > > Once again > Many thanks > Mark. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Performance lag issue Living the Dream <noodnutt@gmail.com> - 2018-02-13 05:12 -0800
Re: Performance lag issue Claus Busch <claus_busch@t-online.de> - 2018-02-13 15:50 +0100
Re: Performance lag issue Claus Busch <claus_busch@t-online.de> - 2018-02-13 20:46 +0100
Re: Performance lag issue Living the Dream <noodnutt@gmail.com> - 2018-02-14 03:27 -0800
Re: Performance lag issue GS <gs@v.invalid> - 2018-02-14 06:31 -0500
Re: Performance lag issue GS <gs@v.invalid> - 2018-02-14 06:34 -0500
Re: Performance lag issue GS <gs@v.invalid> - 2018-02-13 11:20 -0500
Re: Performance lag issue GS <gs@v.invalid> - 2018-02-13 11:34 -0500
csiph-web