name range

  1. S

    Creating a named range using the sheet name in an array sheet Loop - VBA

    I am trying to create a named range for multiple sheets from a specific cell to the last row. What i currently have: Sub test123() Dim wsName As Variant, ws As Worksheet, LastRow As Long For Each wsName In Array("AA-CR", "AA-CP", "AAA-CR", "AAA-CP", "AAT-CP", "AAT-CR") Set ws =...
  2. 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...
  3. 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...
  4. 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...
  5. 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 &...
  6. 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...
  7. 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
  8. 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
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. 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...
  14. 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!
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back