Thanks to Jim & KL. My macro is now more readable and bullet proof.

"KL" wrote:

Hi Bill,

Yes, you can and the sintax is identical:

Set Total_Assets = Sheets("Balance Sheet").Range("MyDefinedName")


Regards,
KL



"Bill Christian" <Bill wrote in message
...
I am not sure how or if you can use the Define Name function in a worksheet
to assign a value in an Macro. I am using the command below to assign a
value
in the worksheet in the macro. However the user might make changes to the
worksheet that makes this method invalid. If I use the Define Name
function
in excel and create a Name can I then us it to assign a value?

Set Total_Assets = Sheets("Balance Sheet").Range("H55")