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

Hi
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?
REQuickendenAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Sheets("sheet name").range("Status").value = "Compete"

Open in new window

or:
[Status].Value = "Compete"

Open in new window

for example.
0
 
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:

http://msdn.microsoft.com/en-us/library/aa139976(office.10).aspx
0
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.