No, afraid it doesn't. But this may be enough for you

Dim AAA As Range

Sub Main
Set AAA = sheet4.cells(35,6)
...
SomeSub
...
End Sub

Sub SomeSub()
AAA = "xyz"
End Sub

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ken Soenen" wrote in message
...
Is there anything in Visual Basic that is similar to SYMBOLIC CONSTANTS as
used in the C Language. For Example, in C:

#define AAA sheet4.cells(35,6)

Sub SomeSub()

AAA = "xyz"

end sub

The compiler encounters the "#define" directive and thereafter replaces
all
occurrences of "AAA" with "sheet4.cells(35,6)". So it then ends up
compiling
the statement:

sheet4.cells(35,6) = "xyz"

thanks,

ken