Please help with do while

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Because i must have ciffers from 1 -9 with 01-02-03 .....
i use this
kur1 = Range("kursist!$g$1").Text
But when i use this in my do while like
Do While kur1 <= kur2
bla bla bla
kur1 = kur1 + 1
Loop
then it don't stop the loop

CAn some one help please - i know how to do it if i dont use 01-02-....
then i can use
kur1 = Range("kursist!$g$1").value

Best regards
alvin
 
Hi Alvin,
I don't understand what you are trying to do.

What data type is kur1?
If kur1 is text, then say kur1 is 'Hello' then kur1+1 is 'Hello1'
What is kur1, what is kur2 (how is it defined, how is it declared)

Regards,
Sebastien
 
Hi
kur1 = Range("kursist!$g$1").Text
In Range("kursist!$g$1").Text I have 01 or 02 or 03 or 04 or 05
...............
so kur1 is 01 or 02 or 03 or 04 or 05 .............

Alvin



"sebastienm" skrev:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy folder 1
Please help with do while 1
Format 2
Supressing a #VALUE! error returned? 3
Between Dates Criteria 4
loop and some more 6
Help with Address property in nested loops 13
Anyone speak Japanese excel? 1

Back
Top