Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
question on how to declare variables. I have something simples like this Sub Test () Dim H1 As Integer H1 = Range("B6").Value MsgBox ("Test number: " & H1 ) End Sub Is there an easy way to use the "H1" value without again having to declare it? Sub Test2 () MsgBox ("Test 2 number : " & H1 ) End Sub -------------------------- thanks for the help again Swingleft |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Declaring Variables | Excel Programming | |||
Declaring Variables Twice? | Excel Programming | |||
Declaring variables | Excel Programming | |||
DEclaring variables | Excel Programming | |||
Declaring variables | Excel Programming |