aking1987,
Do you mean:
Dim cellalphanumber As String
If SomeCondition=True Then
cellalphanumber = "Something Else"
Else
cellalphanumber = "D"
End If

NickHK

"aking1987" wrote in message
...

Is it possible to define a variable, say "cellalphanumber" as "D" as
part of the ELSE within an if then else statement.

So if its ELSE it will define cellalphanumber = D

Can this definition be used within another sub?


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