View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Defining a variable within a sub...

aking1987,
No, what is your problem ?

NickHK

"aking1987" wrote in message
...

Code:
--------------------

Sub EXAMPLe
Dim cellalphanumber As String
If SomeCondition=True Then
EXAMPLE1
cellalphanumber = "E"
Else
EXAMPLE1
cellalphanumber = "D"
End If

END SUB

SUB EXAMPLE1

msgbox cellalphanumber
END SUB
--------------------

can you see where my problem is?


--
aking1987
------------------------------------------------------------------------
aking1987's Profile:

http://www.excelforum.com/member.php...o&userid=15393
View this thread: http://www.excelforum.com/showthread...hreadid=277313