View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nicolas Roth Nicolas Roth is offline
external usenet poster
 
Posts: 5
Default global variables

Hello, i have been searching the threads to get some info, but nothing
answered 100% my question. Is there another way to have access to the
variable size than using the call in the following code:


Option Explicit
Public size As Integer

Public Sub test1()
size = Cells(1, 1)
End Sub

Public Sub test2()
Call test1
Cells(2, 1) = size * 2
End Sub

thanks, Nicolas