Thanks for all your replies. The suggestions for using the SET keyword and
RANGE gives me what I'm looking for. Which is using a "descriptive" name
instead of the cell location.

thanks,
ken

"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