Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.basic.visual.misc > #735
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| 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 | Tue, 07 Feb 2012 12:58:23 -0500 |
| Organization | A noiseless patient Spider |
| Lines | 19 |
| Message-ID | <jgrons$jbg$1@dont-email.me> (permalink) |
| References | <528cb6d4-caa7-4fb9-9bfa-e0f903ed2107@w4g2000vbc.googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset="iso-8859-15"; format=flowed |
| Content-Transfer-Encoding | 8bit |
| Injection-Date | Tue, 7 Feb 2012 17:58:20 +0000 (UTC) |
| Injection-Info | mx04.eternal-september.org; posting-host="UVJBuiIZprDyxzUkJsiwfw"; logging-data="19824"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Q336Dp7o7tcp2pDFOi/A5" |
| X-Antivirus-Status | Clean |
| X-Newsreader | MesNews/1.08.03.00-gb |
| X-Antivirus | avast! (VPS 120207-0, 02/07/2012), Outbound message |
| Cancel-Lock | sha1:u42sg5dSDbFBsUuwDLPtIVjSibk= |
| X-ICQ | 543516788 |
| Xref | x330-a1.tempe.blueboxinc.net comp.lang.basic.visual.misc:735 |
Show key headers only | View raw
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. -- 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 | Next in thread | Find similar | Unroll thread
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