Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Vista General Discussion > Looping and If Structures

Reply
Thread Tools Display Modes

Looping and If Structures

 
 
horsepro001
Guest
Posts: n/a

 
      04-24-2008
Please help, and thank you in advance. I am trying to loop the following If
Structure until Range("E2") = "":

If Minus1Var >= ABCvar3 Then
ABCvar4 = Minus1Var * Range("E2")
Range("E2").Delete Shift:=xlUp
Range("D2").Select
Range("D2").Insert Shift:=xlDown
Range("D2").Select
Range("D2").Value = ABCvar4
Range("D2310").Select
Selection.Sort Key1:=Range("D2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End If
 
Reply With Quote
 
 
 
 
Malke
Guest
Posts: n/a

 
      04-24-2008
horsepro001 wrote:

> Please help, and thank you in advance. I am trying to loop the following
> If Structure until Range("E2") = "":
>
> If Minus1Var >= ABCvar3 Then
> ABCvar4 = Minus1Var * Range("E2")
> Range("E2").Delete Shift:=xlUp
> Range("D2").Select
> Range("D2").Insert Shift:=xlDown
> Range("D2").Select
> Range("D2").Value = ABCvar4
> Range("D2310").Select
> Selection.Sort Key1:=Range("D2"), Order1:=xlAscending,
> Header:=xlGuess, _
> OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
> End If


You've posted in a newsgroup dealing with general questions about the
Windows Vista operating system. You should post programming questions in a
programming newsgroup. Here is a list of all the public MS newsgroups:

http://aumha.org/nntp.htm

If you don't see what you're looking for there, posting in a non-MS
newsgroup for developers in whatever programming language you are using
would be the next step.

Malke
--
MS-MVP
Elephant Boy Computers
www.elephantboycomputers.com
Don't Panic!
 
Reply With Quote
 
Richard G. Harper
Guest
Posts: n/a

 
      04-24-2008
Vista doesn't loop - it soars.


If you have a question about a specific programming language, macro or
application software you would do better to post that question in a
newsgroup specific to the application software or programming language
you're trying to use.

--
Richard G. Harper [MVP Shell/User]
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/


"horsepro001" <> wrote in message
news:AD974F21-6748-4F45-8816-...
> Please help, and thank you in advance. I am trying to loop the following
> If
> Structure until Range("E2") = "":
>
> If Minus1Var >= ABCvar3 Then
> ABCvar4 = Minus1Var * Range("E2")
> Range("E2").Delete Shift:=xlUp
> Range("D2").Select
> Range("D2").Insert Shift:=xlDown
> Range("D2").Select
> Range("D2").Value = ABCvar4
> Range("D2310").Select
> Selection.Sort Key1:=Range("D2"), Order1:=xlAscending, Header:=xlGuess,
> _
> OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
> End If


 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
safe mode looping Bruce Windows Vista General Discussion 1 12-22-2007 01:47 PM
Looping message on windows VR on every boot up SAL Windows Vista General Discussion 0 09-13-2007 02:34 PM
Looping Reboot at Login Screen bside Windows Vista Installation 0 09-11-2006 04:04 AM
Solitaire & Hearts looping animation sound bug ZAZ Windows Vista Games 3 08-13-2006 09:58 AM
Looping at start GWC Windows Vista Installation 0 06-21-2006 12:20 AM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59