name range

  1. O

    VBA Cell Formula to Name Range

    Thanks in advance for any suggestions for which I will give feedback. I am trying to set cell to a formula involving name ranges. Where, for example cell D53 [Cell(53,4)] formula would be = V1.Total.NPV10 + V2.Total.NPV10 + V3.Total.NPV10 + V4.Total.NPV10 + V5.Total.NPV10 since the value in...
  2. B

    Naming Ranges using VBA

    I have a database that will be constantly changing in length and for purposes of conditional data validation, I want to name hundreds, potentially thousands of ranges. I have made it far enough to get a table on a separate sheet with what I want the name of each range to be in column A and the...
  3. R

    Select Cells based on other Cells Value

    Hello Everyone, I am working on database and need your help in one macro. I have one drop down linked with V1 and have one search box. V1 will be the country name. So i want If V1 is australia then C8:P9 should be selected and cursor automatically reach on C3. Same if V1 is Austria then...
  4. L

    Add +1 to Name of Named Range

    Hi everyone, I've got a list of 700+ phrases that I'd like to refer to at numerous points throughout a workbook. I'd like to copy and paste this list throughout the workbook, so used named ranges so I can refer to those specific cells. I thought this'd be easier rather than manually selecting &...
  5. S

    Automatically Unhide Columns on GoTo

    I have a sheet1 with sets of grouped (hidden with + box or visible with the - box) columns. Each group of hidden columns is a Named Range. On sheet2 I have cells/formulas linking to the grouped/hidden columns/cells on Sheet1. When I jump (doubleclick or Ctrl-G) from Sheet2 to a specific...
  6. M

    This is a tough one : deleting names, but in a specific range in VBA

    Hello, I am trying to figure out how to delete names of ranges in a specific range, using vba code. I tried this : ActiveWorkbook.Worksheets("Sheet1").Range("e6:bx2000").Names.Delete but it doesn't work. I googled it... got nothing :eeek: Please help
  7. E

    Variable Name Range Reference (VBA)

    Hi, I'm writing code to name ranges and the actual name varies. Im using the following expression but its not working. Below "name" is a variable. Can somebody help me with this? ActiveWorkbook.Names.Add name:="cstr(name)", RefersTo:=Selection Thanks for your help in advance. Juan
  8. S

    Data List box with multiple sheets

    When i do a drop down Data list, and I create a formula in the name range, it always puts the current worksheet name in the formula. So every new month I have to create a new name range formula. How can I tell the name range formula to always look in the current sheet. Here is my formula...
  9. R

    Delete name range from selected cells

    Hi guys, Hoping someone out there can help me. Think it will be pretty easy but here goes. Trying to write a macro that will choose a selected range (E2:T200) on a secific worksheet (Edit) and delete the name range for that range without touching the rest of the workbook. Any help will be...
  10. R

    Continue macro on next row

    Hi there, I am new to VBA and have this code Sub Rename() 'Rename Range("F2:P2").Name = Range("B2") End Sub Can someone tell me how to progress this automatically to the next row eg: Range("F3:P3").Name = Range("B3') etc, and so on to say about 2000. Hope this makes sense. Thanks in advance
  11. K

    Indirect function for continuously changing range

    Hi. I have this little program where you can add items to an index (it's do with foods). So you select the food category the food belongs to then the macro will put it in the respective place in the index (under the correct category heading and in alphabetical order). I then draw from this index...
  12. D

    Excel Macro to Create Independent Data Validation Lists

    I am writing a Macro in excel VBA that creates a data validation list in a specified cell. The program then prompts the user for the cells which contain the contents of the data validation lists. The same rows containing the list contents are then to be hidden from view. However, when I try...
  13. H

    Name Range linked to multiple worksheets?

    DELETE THREAD, I feel like an idiot, I figured it out....! But see, this is why I figured it out, had to post something about it first, LOL SORRY Message board!
  14. J

    Inserting rows above formula: how to?

    Hi, I'm a dunce in Excel, but actually managed to insert an "average" formula, though would like to add more data above it, to average more cells. If this is answered in another thread/post here, feel free to send me its link. I was unable to find it. I saw something on another site talking...
  15. M

    Offset discontinuous range

    Hello, here's the thing. I want to select a range of values but this ranges are not continuous. I tried =OFFSET(I21;;;;2)&OFFSET(I21;;5;;3) I would need this to select I21,I22,I26,I27,I28 I'm trying to define a Name Range with this, but as I test it, it won't be highlighted as a range. I...
  16. pedie

    New name range created showing range as '"Sheet2!$A$1" and not Sheet2!$A$1.

    hi, myname range created is showing range as '"Sheet2!$A$1" instead of Sheet2!$A$1 when i hit ctrl + f3 and checked it... I need to name a range for all the words in col a if not blank. I got this far but names are created with error. Please advice on how to correct this. My current code as...
  17. pedie

    Need help with my code. Thanks

    Hi everyone! I have made a sample code that is only for col C:C. In row 3 i have heading that I want it to be a range name. eg like help_1 etc Whatever word in there in row 3 for each col i want the code to pick that up and then name the range select the whole colyumn.... The code will continue...
  18. R

    Search for text in name range in Sheet 1and return Value in Sheet 2

    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...
  19. C

    CountIF problems and range

    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...
  20. C

    Named range in several worksheets

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top