+ Reply to Thread
Results 1 to 2 of 2

hi:daily used

Hybrid View

  1. #1
    Registered User
    Join Date
    10-18-2006
    Posts
    12

    hi:daily used

    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

  2. #2
    Registered User
    Join Date
    10-18-2006
    Posts
    12

    Talking hi

    I resolved the problem completely.

    Thanks for help anyway..


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1