-
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.
local names
-
D
local range names within Threed function?
I am attempting to use conditionally sum across multiple tabs using the "threed' function. What I have found - using the threed function with cell references appears to work. For example this formula proves successful...- DEllis81
- Thread
- local names threed
- Replies: 2
- Forum: Excel Questions
-
B
Local names remain when sheet is deleted
I have a really weird problem. I have a lot of local names on many of my sheets in my workbook. The sheets are deleted by VBA macros. Now, for some of my sheets the local names are converted to global names and the sheet name becomes REF#. Is there some kind of logic behind when this happens...- bk1
- Thread
- local names scope convertion sheet deletion
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Dynamic cell and sorting
- Started by Polanskiman
- Replies: 31
So here is the deal. I need that cell in E4 to be dynamic because the "Description" column on the Excel table is supposed to be sortable. By... -
How do I get combobox to get a cell number then link it to a selection from a checkbox in Excel?
- Started by Ayugma
- Replies: 31
I have no idea how to really implement this. So I have 5 checkboxes, all of which are parts to a machine. So, a user will be able to select as... -
VBA code works on works desktop but not on my own laptop
- Started by Monojono
- Replies: 30
Hello Readers and hopefully problem solvers, I have a large amount of coding across my workbook that works fine on my works desktop. However, on... -
Formulas referencing Pay Dates in year
- Started by rishijain11
- Replies: 27
Hi, I'm trying to build out this excel file to keep track of my finances. I could use some help with several formulas revolving around the pay... -
Sorting key
- Started by dpaton05
- Replies: 25
When you are sorting using range.sort method, one of the parameters is Key. If I want to sort by column A, with the header being in row 3 and the... -
Copy Range of Cells And Paste Until Last Row
- Started by Unexpc
- Replies: 21
Hi guys i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?