Solved

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

Posted on 2011-02-24
2
330 Views
Last Modified: 2012-06-21
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
Comment
Question by:REQuickenden
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 125 total points
ID: 34969793
Sheets("sheet name").range("Status").value = "Compete"

Open in new window

or:
[Status].Value = "Compete"

Open in new window

for example.
0
 
LVL 24

Expert Comment

by:broomee9
ID: 34969896
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question