Groups > comp.lang.basic.visual.misc > #736

Re: I'm getting run time error 1004 and I need help editing my code

From	"blank" <blank@blankety.blank.com>
Newsgroups	comp.lang.basic.visual.misc
References	<528cb6d4-caa7-4fb9-9bfa-e0f903ed2107@w4g2000vbc.googlegroups.com> <jgrons$jbg$1@dont-email.me>
Subject	Re: I'm getting run time error 1004 and I need help editing my code
Date	Wed, 8 Feb 2012 05:08:54 +1100
Lines	24
X-Priority	3
X-MSMail-Priority	Normal
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646	Format=Flowed; Response
NNTP-Posting-Host	220.245.83.181
X-Original-NNTP-Posting-Host	220.245.83.181
Message-ID	<4f3168b9$1@dnews.tpgi.com.au> (permalink)
X-Trace	dnews.tpgi.com.au!tpg.com.au 1328638137 220.245.83.181 (8 Feb 2012 05:08:57 +1100)
Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!news.musoftware.de!wum.musoftware.de!news.ripco.com!rahul.net!wasp.rahul.net!rahul.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!nntp3.phx1!dnews.tpgi.com.au!tpg.com.au!not-for-mail
Xref	x330-a1.tempe.blueboxinc.net comp.lang.basic.visual.misc:736

Show key headers only | View raw

This is odd. I have the reply here but not the original post!

"GS" <gs@somewhere.net> wrote in message news:jgrons$jbg$1@dont-email.me...
> 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

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