View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Swingleft Swingleft is offline
external usenet poster
 
Posts: 14
Default only 1 time declaring variables

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