• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

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?
0
REQuickenden
Asked:
REQuickenden
1 Solution
 
Rory ArchibaldCommented:
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now