Digita
09-11-2007, 12:04 AM
Hi All,
In a new workbook I have:
Sub InputData()
With Sheet1
.Range("A1").ID = "xyz"
.Range("A2").ID = 2 ^ 2 * 5
.Range("A3").ID = .Range("A2").ID + 1
.Range("A4").ID = Format(Now, "medium date")
End With
End Sub
The above code stores values in range A1:A4. The following code displays the values in A1, A3 & A4.
Sub ShowValue()
With Sheet1
MsgBox .Range("a1").ID & " " & .Range("a3").ID & " " & .Range("a4").ID
End With
End Sub
I now save & close this workbook. Then I reopen same & run the ShowValue routine. All the stored values disappear. Memorywise, does the Id property work on the same concept as setting public variables in a project?
Thanks in advance for your input.
Kind regards
KP
In a new workbook I have:
Sub InputData()
With Sheet1
.Range("A1").ID = "xyz"
.Range("A2").ID = 2 ^ 2 * 5
.Range("A3").ID = .Range("A2").ID + 1
.Range("A4").ID = Format(Now, "medium date")
End With
End Sub
The above code stores values in range A1:A4. The following code displays the values in A1, A3 & A4.
Sub ShowValue()
With Sheet1
MsgBox .Range("a1").ID & " " & .Range("a3").ID & " " & .Range("a4").ID
End With
End Sub
I now save & close this workbook. Then I reopen same & run the ShowValue routine. All the stored values disappear. Memorywise, does the Id property work on the same concept as setting public variables in a project?
Thanks in advance for your input.
Kind regards
KP