473,777 Members | 1,715 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Got this error when I use "loop until" in the same module

1 New Member
Till here the info gotten is ok

Loop Until strainfo = ""
ScreenMNS.WaitH ostQuiet (400)

Second process

Copy "B" & paste in "E"

Range("B2:B600" ).Select
Selection.Copy
Range("E2").Sel ect
ActiveSheet.Pas te
Selection.Repla ce What:=" ", Replacement:="" , LookAt:=xlPart, _
SearchOrder:=xl ByRows, MatchCase:=Fals e, SearchFormat:=F alse, _
ReplaceFormat:= False




then I want to star other process from E2 and the error is on the next loop until

it say´s
" loop without do


this is what I just add


Loop Until strcontrol = ""
ScreenMNS.WaitH ostQuiet (400)
Feb 13 '08 #1
2 1476
kadghar
1,295 Recognized Expert Top Contributor
Till here the info gotten is ok


" loop without do


this is what I just add


Loop Until strcontrol = ""
ScreenMNS.WaitH ostQuiet (400)
LOOP is for closing DO, e.g.

Expand|Select|Wrap|Line Numbers
  1. dim i as long
  2. dim j as long
  3. i=1
  4. do 
  5.     j = j+i
  6.     i = i+1
  7. loop until i > 10
this will make j = 55 (the sum from 1 to 10)

HTH
Feb 13 '08 #2
Killer42
8,435 Recognized Expert Expert
Yes, the Loop statement goes at the end of a loop, not the start.
Feb 14 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

11
2265
by: Wayne Folta | last post by:
Two observations about PEP-315: 1. It's clever, addresses a definite "wart", and is syntactically similar to try/except. But it's syntax seems like an acquired taste to me. 2. It is a very general construct, which might be what is called for. But I wonder if most of the time it would be used to accomplish something like:
6
71981
by: John Pass | last post by:
What is the difference between a While and Do While/Loop repetition structure. If they is no difference (as it seems) why do both exist?
3
2254
by: Patrick Sullivan | last post by:
In this for loop, IE skips over the animation function until the end of the loop and only aninmates the last phrase. Firefox does it right. Loop is right below, entire script is below that. This script uses the Yahoo GUI library (beta) for animation. for (var c=0; c < index; c++) { document.getElementById("sample").innerText = myArray; var myanim = new YAHOO.util.Anim('sample', { fontSize: {from: 0, to: 50}, opacity: {from: 0.5, to: 1}
34
2690
by: Frederick Gotham | last post by:
Is the domestic usage of the C "for" loop inefficient when it comes to simple incrementation? Here's a very simple program that prints out the bit-numbers in a byte. #include <stdio.h> #include <limits.h> #include <stdlib.h> int main(void) {
2
3230
by: recordlovelife | last post by:
So I am trying to display a title, date, and content of a wordpress blog. Word press provides nice drop in functions to get the job done with simple names like "the_title", and the "the_content" But on the homepage of a site, i wanted to truncate the content to like the first 75 characters and then put "..." (a perfect use of the smarty "truncate" modifier) and then give the visitor a link to read the whole article. But since "the_content" is a...
1
1203
by: WiscCard | last post by:
I have an Access report that I need to print the 1st page on letterhead and the 2nd page on blank paper, then move on to the next record and do the same. I used the VBA code at the below link exactly and it works perfect, except that it literally does the 1st and 2nd pages and then stops. It does not move on to the next record in the report. Is there any way to add a "loop" or something to this module so that it executes this command...
15
2367
by: Steve | last post by:
I am having problems getting values out of an array. The array is set as a global array and values are pushed into it as they are read from a JSON file using a "for loop". When the "for loop" is finished I want to convert the array into a string which can be used by another function. My attempt to do this is not working. The script looks like this: heights=; function getElevationInter(latv,lngv) { var script =...
9
1569
by: Alexnb | last post by:
Okay, so lets say you have a list: funList = and you do: for x in funList: print x this will print 1-5
6
2505
by: Alexnb | last post by:
Uhm, "string" and "non-string" are just that, words within the string. Here shall I dumb it down for you? string = "yes text1 yes text2 yes text3 no text4 yes text5+more Text yes text6 no text7 yes text8" It doesn't matter what is in the string, I want to be able to know exactly how many "yes"'s there are. I also want to know what is after each, regardless of length. So, I want to
0
9628
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10292
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10122
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7471
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6722
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5368
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5497
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3627
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2860
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.