can anyone tell me what is wrong with this LOOP, because it doesn`t get out of it. How do I write condition DO WHILE RAZLIKA ( engl. division ) is lover than 1h30min.
This is for macro i`ve been writing
` DO ZANKA ( 1h30min = 0.0625 )
Do While RAZLIKA <= 0.0625
` NASTAVITEV SPREMENLJIVK ( engl. seeting variables )
CELICA2 = "A" & INDEKS + 1
CELICA3 = CELICA2 & ":" & CELICA2
' NASTAVITEV KAZALCA IN IZRAČUN RAZLIKE ( engl. seeting the pointer and then divide )
For Each VREDNOST In Range(CELICA2)
KAZALEC = VREDNOST.Value
Next
RAZLIKA = KAZALEC - CELICA1
' IZPIS RAZLIKE MED CELICAMI ( engl. write equasion of division on screen )
Range("G1").Select
ActiveCell.FormulaR1C1 = RAZLIKA
Selection.NumberFormat = "h:mm:ss;@"
' POVEČANJE INDEKSOV ( engl. increment variables )
MERITEV = MERITEV + 1
Loop
Bookmarks