name range

Hi, I have something of the following : Shee 1 (Name Range : Code) Column A -------- Column B School ----------- 1 College ----------- 2 University--------- 3 Sheet 2 Cell A1 = (Search for "College" in Name Range Code and get the Value of "2" as code. ) So value of 2 should be present in...

Hi Folks, I have a range that I would like to use to COUNT all the fields I have a value greater than 10. I konw I can amend my VB to suit, but its proving a difficulty. Not least because i am not doing the VB element. I have a data set that is returning values that are either 1. Greater...

Hello, Below is some code I'm trying to use that will name cell in col C based on cell value in col B. However, when I run this macro the named range is only working in 1 worksheet. To give a little background, I've got a workbook with several sheets for each company. On each sheet col B...

I've been looking everywhere for this answer with no luck, so props to whomever can tackle this! What I need is the code for naming a range that's been filtered. For example, in my macro I'm telling it to filter like so: Selection.AutoFilter Field:=2, Criteria1:="320" Now, what I need to...

I have a 2003 worksheet with Defined Name Ranges. If I run it in 2007, do I have to re-create them? The Named Ranges seem to have been lost when I run 2007. Can it be easily converted?

Hi, Can anyone help me with this one.... I'm playing around with name ranges in excel and I'm finding it very useful for a task I'm trying to do, but I'm hitting a problem that I can't seem to find a solution for. If I name a range of 20 items in a list starting in cell A6 for instance, and I...

I haven't been able to find a code to name a range in each worksheet with the name of the worksheet. Would this be possible? I have the below so far. Am I heading in the right direction? Do I need to do something else? Sub Add_ALL_Budgets() Dim Awb As Workbook Dim ws As Worksheet...

I have a worksheet that contains formulas which in turn contains names. Using VBA, I'd like to replace all names that occur in formulas with value of the cell that the name refers to. The code below does not replace names when the value of the cell the name refers to is a text string. For...

Help! Reference cell A1 is a dropdown list value selected in A1 needs to influence the display of other dropdown lists in A2 and A3. So if user select "Book" in A1, then the list in A2 will display its list's for additional selections but the list for A3 will not show. If user selects "Car"...

I have defined a name range of LoanAmount =E389 which currently is a value of $9,028,000 in a section of my worksheet. I am also writing a summary paragraph of the deal overview at the top of my worksheet as a text narrative but want to insert the definition LoanAmount in the body of the text...