-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
vba named range
-
Looping through an array
Hi Guys, and Happy New Year to everybody! I am trying to build something like a widget. I created shapes that are named in this fashion: A01_TrafficLight, A02_TrafficLight, B03_TrafficLight etc... I have the corresponding list of names in a named range on a sheet ie: A01, A02, B03... How can I...- szita2000
- Thread
- set vba array from named range vba array vba dynamic array vba named range
- Replies: 2
- Forum: Excel Questions
-
D
VBA Adding a row to a named range
I have a list of names in a named range "Player_Names" When I do a Vlookup into this named range, if I do not find the name, I want to add the name to the end of the list and modify the named range to include the new row. I'm new to VBA and would appreciate any help. Thanks.- davebliz
- Thread
- vba named range
- Replies: 1
- Forum: Excel Questions
-
R
VBA to delete external named ranges (or with #REF in the named range value)
I am attempting to delete external named ranges after a sheet is copied out of a source workbook (the template). I have tried both the following codes, but neither one does the trick. The code is in ThisWorkbook (not a module), and I have tried it with the code both in the template and the new...- Reddog94
- Thread
- named ranges vba vba delete named ranges vba named range
- Replies: 1
- Forum: Excel Questions
-
R
Excel Named Ranges Change Name via VBA
Guys - I have inherited a spreadsheet with hundreds of redundant named ranges. I want to delete them all via VBA. I did the usual by using nm.Delete where nm is the variable Name object. It works fine except that there are names which have blanks embedded, eg. "Direction_20_1_ 2" or "South...- ramridge
- Thread
- named range vba vba named range
- Replies: 8
- Forum: Excel Questions
-
J
VBA with a named range across multiple sheets
Hi all- Got what I hope is a fairly simple vba question. I am working with a 7 sheet workbook, and each sheet includes (among other things) about 10 input cells. I have used the name manager to define the entire range of those input cells (across all sheets) as "input". I was hoping to write...- jlg
- Thread
- multiple sheets in vba vba named range
- Replies: 6
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Payment term and Cash flow (formula linked with costs)
- Started by Adfinance
- Replies: 43
Hi everyone, I need to calculate automatically the cash position (cashout) based on payment terms and costs. The payment terms may change, so I... -
Match to a list with wildcards
- Started by The Gent
- Replies: 29
Good day all, I am trying to do something which it my head feels quite simple but I can't get a result. I have four dimensions in a spreadsheet... -
Inserting text above first blank row then above third blank row etc.
- Started by Livin404
- Replies: 24
Greetings, I have a VBA where I'm trying to insert text into blank cells. On worksheet "Deficiencies" I have seven groups of ranges that I... -
code to get students marks from source sheet to destination sheet.
- Started by rzml
- Replies: 22
hi, I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I... -
Run VBA on all open tabs
- Started by Dannottheman
- Replies: 22
Hi, I searched but could not find an answer to this. How can I make the 3 VBAs below run on all the open sheets/tabs in my Excel? Right now I... -
Functions to separate a string separated by commas
- Started by jeffdolton
- Replies: 22
Hi, I’ve opened up another thread as my request this time is a little different. With help from experts on this forum, and using some basic excel...