Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 22nd, 2007, 07:54 PM
Registered User
 
Join Date: May 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to gauravhyd Send a message via MSN to gauravhyd Send a message via Yahoo to gauravhyd
Default limiting a macro to terminate after row 600

Previous developer in my company developed a macro for us.

He has set to terminate the macro if the rows are more than 600

i dont know how he did that

Is there anyway by which i can increase that size to 800 or so??


Please advise.

you can mail replies to bunty.gupta@yahoo.com

Thanks
 
Old May 29th, 2007, 09:21 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 163
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Need to see the loop being used before it's possible to explain how to do it. I'd suggest figuring when to end based on other criteria other than number of lines. In any case, If it's a for/next loop, it's probably something like:
--------------------------------------------------------
For iCnt = 1 to 600 'change last number to 800
  **processing code**
Next
--------------------------------------------------------

If it's a Do/While loop, it's probably more like:
--------------------------------------------------------
Do while iCnt < 601 'Change to 801 here
  **Processing here**
  iCnt = iCnt + 1
Loop
--------------------------------------------------------

This is very basic looping. It also could be looping through a range:
--------------------------------------------------------
  Set rMyRange = Range("A1:A600") 'Change range to end at A800 in this example
  For Each rCell in rMyRange
    **Processing Code**
  Next
--------------------------------------------------------






Similar Threads
Thread Thread Starter Forum Replies Last Post
calling to xlam macro from macro inside xlsb SteveB Excel VBA 0 June 30th, 2008 06:43 PM
Terminate Process (How To) Nova Beginning VB 6 3 October 14th, 2006 02:37 PM
Macro script to select a row acgunn Excel VBA 1 July 27th, 2006 04:13 PM
800 x 600 Display issues Any Ideas ru1 Access 0 March 17th, 2005 05:00 PM
terminate a thread problem lmadhavi Visual C++ 0 November 23rd, 2004 06:20 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.