Is there a way for the variable to retain it's value to use it in another
Sub?
See example. I need for Cell_Transfer to keep it's value to use it in
Static_Test or elsewhere

please help



Sub Static_Test()
Call Find_Next_Cell
MsgBox Cell_Transfer
End Sub

Sub Find_Next_Cell()
Dim My_Cell As Range
Static Cell_Transfer

For Each My_Cell In Range("D6:IV6")
If My_Cell.Value = "" Then GoTo when_blank
Next
when_blank:

Cell_Transfer = My_Cell.Address
End Sub