From: "blank" Newsgroups: comp.lang.basic.visual.misc References: <528cb6d4-caa7-4fb9-9bfa-e0f903ed2107@w4g2000vbc.googlegroups.com> 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> 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 This is odd. I have the reply here but not the original post! "GS" 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 > >