Pls find the vba code I'm trying to run. I understand that I get this error. Because when I run macro1() , I'm calling a variable which is not yet initialized/declared. Is there a way to initialize public variable before procedure call. 

Help me on this. If i'm wrong at my understanding, Correct me.

Note: I'm running this as Excel addins.

```
Public bugr As Variant
Public bugr_sheet As Variant
Public bugr_cell As Variant
Public scr As Variant

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+e

'Getting current cell address
Set bugr_sheet = ActiveSheet
Set bugr_cell = ActiveCell
bugr = ActiveSheet.Name & "!" & ActiveCell.Address

'Creating dummy link
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
    bugr, TextToDisplay:="NA"

End Sub
Sub Macro2()
'
' Macro2 Macro
'
' Keyboard Shortcut: Ctrl+l
'
scr = ActiveSheet.Name & "!" & ActiveCell.Address
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
    bugr, TextToDisplay:=bugr

    bugr_sheet.Activate
    bugr_cell.Activate
    Selection.Hyperlinks(1).SubAddress = scr
    Selection.Hyperlinks(1).TextToDisplay = scr
   End Sub

```