Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Integer Variables back to Zero
You can reset non-object variables to their default values using Empty:
Dim i As Long Dim s As String i = 10 s = "ttt" i = Empty s = Empty Debug.Print i, Len(s) Object require Nothing ; Dim o as object Set o=Nothing NickHK "Kou Vang" wrote in message ... I am running several loops and was wondering how do I reset the Integer variables back to 0? I tried putting the Dim Statements inside the loop but that didn't work. This must be so easy, but it's like math, I don't remember remedial stuff only what's most recent. Same goes in programming...Sigh... Kou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
copy back macro/roll back | Excel Worksheet Functions | |||
Concatenate two variables (String & Integer) | Excel Programming | |||
Declaring variables (Long, String, Integer) and interpretation spe | Excel Programming | |||
4 variables to one sheet, then back to original sheet with answer | Excel Programming |