ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula outcomes (https://www.excelbanter.com/excel-discussion-misc-queries/156229-formula-outcomes.html)

biker man

formula outcomes
 
can anyone tell me if theres any errors in this and what the outcome
would be?

sub test ()


dim I, J As Integer
dim x as single
for i = 1 to length
for j = 1 to (length - i)
If A(j) < A )j +1) Then
x = a(j +1) = A(j)
A(j) = x
end if
next j
next i
end sub


Pete_UK

formula outcomes
 
See responses elsewhere - please do not multi-post.

Pete

On Aug 29, 12:47 pm, biker man wrote:
can anyone tell me if theres any errors in this and what the outcome
would be?

sub test ()

dim I, J As Integer
dim x as single
for i = 1 to length
for j = 1 to (length - i)
If A(j) < A )j +1) Then
x = a(j +1) = A(j)
A(j) = x
end if
next j
next i
end sub




David Biddulph[_2_]

formula outcomes
 
Please don't multipost.
--
David Biddulph

"biker man" wrote in message
oups.com...
can anyone tell me if theres any errors in this and what the outcome
would be?

sub test ()


dim I, J As Integer
dim x as single
for i = 1 to length
for j = 1 to (length - i)
If A(j) < A )j +1) Then
x = a(j +1) = A(j)
A(j) = x
end if
next j
next i
end sub





All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com