Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 10
Default while loop

can anyone tell me what is the wrong with this loop? Excel is not going inside this loop.

Do While R(j).Value < R(j - 1).Value And j 1
k = 1
temp = R(j).Value
R(j).Value = R(j - 1).Value
R(j - 1).Value = temp
j = j - 1
Loop


Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loop Heather O'Malley Excel Discussion (Misc queries) 1 November 6th 06 02:39 PM
How would I add a loop for this? [email protected] Excel Discussion (Misc queries) 3 September 18th 06 01:21 PM
loop Wanna Learn Excel Discussion (Misc queries) 14 September 1st 06 12:36 AM
Any way to loop this in VBA? Bill (Unique as my name) Excel Discussion (Misc queries) 5 February 22nd 06 11:04 PM
Please help with loop Mike C Excel Discussion (Misc queries) 3 January 29th 05 02:31 PM


All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"