Use an excel macro to set a "named" cell...

I have a small marco in Excell (triggered by a button) which i want to "reset" then values of a number of "named" cells in excel (from the same workbook)

The name of the range for example is called "Status" so i wanto to set the value of that cell to "Compete" for example.

I thought this would be straight forward but having trouble...any advce/thoughts?
Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
Sheets("sheet name").range("Status").value = "Compete"

Open in new window

[Status].Value = "Compete"

Open in new window

for example.
TracyVBA DeveloperCommented:
NFP as Rory already answered the question.  But there are many ways to do it, I've found this link especially helpful when working with ranges:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.