Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.basic.visual.misc > #738
| From | GS <gs@somewhere.net> |
|---|---|
| Newsgroups | comp.lang.basic.visual.misc |
| Subject | Re: I'm getting run time error 1004 and I need help editing my code |
| Date | 2012-02-07 14:25 -0500 |
| Organization | A noiseless patient Spider |
| Message-ID | <jgrtqc$jfo$1@dont-email.me> (permalink) |
| References | <528cb6d4-caa7-4fb9-9bfa-e0f903ed2107@w4g2000vbc.googlegroups.com> <jgrons$jbg$1@dont-email.me> <Xns9FF27CC6A1195auricauricauricauric@88.198.244.100> |
After serious thinking Auric__ wrote : > GS wrote: > >> Lots of issues with this! >> Firstly, you need to ask your Q in an Excel group. This group is for >> Classic VB NOT Excel VBA! >> >> Secondly, obviously your code is a rework of using the most inefficient >> macro recorder. >> >> Thirdly, none of your variables are declared. >> >> Fourthly, there's way, way, way too much unnecessary range selecting >> going on, making for rather poor performance. > > Gee, Garry, tell us how you *really* feel. ;-) Sorry about that! I have a really nasty pet peeve about how much junk code Excel's macro recorder generates!<g> I'd be happy to 'clean it up' IF the OP posts to an appropriate NG I subscribe to... -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc
Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Find similar
I'm getting run time error 1004 and I need help editing my code Jose Perez <jperezberrios@gmail.com> - 2012-02-03 14:28 -0800
Re: I'm getting run time error 1004 and I need help editing my code GS <gs@somewhere.net> - 2012-02-07 12:58 -0500
Re: I'm getting run time error 1004 and I need help editing my code "blank" <blank@blankety.blank.com> - 2012-02-08 05:08 +1100
Re: I'm getting run time error 1004 and I need help editing my code GS <gs@somewhere.net> - 2012-02-07 14:59 -0500
Re: I'm getting run time error 1004 and I need help editing my code "blank" <blank@blankety.blank.com> - 2012-02-08 07:09 +1100
Re: I'm getting run time error 1004 and I need help editing my code GS <gs@somewhere.net> - 2012-02-07 15:56 -0500
Re: I'm getting run time error 1004 and I need help editing my code "blank" <blank@blankety.blank.com> - 2012-02-08 10:48 +1100
Re: I'm getting run time error 1004 and I need help editing my code "Auric__" <not.my.real@email.address> - 2012-02-07 19:15 +0000
Re: I'm getting run time error 1004 and I need help editing my code GS <gs@somewhere.net> - 2012-02-07 14:25 -0500
csiph-web