Solved

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

Posted on 2011-02-24
2
328 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

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

777 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