name

Hello, I've just encountered a strange formula evaluation issue where only two cells using a custom formula are returning #NAME? instead of the cell value it's supposed to return. The table currently has 127 records, and it's only two values where this issue is occurring even though the...

I have the following code that show details of a filtered PivotTable in new worksheets. I want to create new PivotTable in these new worksheets and have the following code but I keep on running into the object required error on the Set Tbl = d.Parent.Cells(d.Row, lCol).Name line? How do I fix...

Hello All...please someone help a VBA code that can automate copy of sheet from open workbook and paste to other but closed workbook. Then overwrite if sheet name exist. Example as follows: Open File1 = main file, have the sheet name "report". Consist macro that copy the sheet name "report" to...

How would I create a macro that removes all the rows where there is a #NAME? error in Column E?

XERROR allows for conveniently generating most of the Excel errors as output to functions With XERROR, it is very easy to generate all but four of the Excel errors as output to functions. Error types 0, 1, 2, 3, 4, 5, 6, 7, 8, 13, and 14 (i.e. #EXTERNAL!, #NULL!, #DIV/0!, #VALUE!, #REF...

Hi, I have a substantial (and dynamic) list of names that I'm needing to transform into email addresses. For names like Bob Smith, and even those with hyphens (Sarah-Jane Brown), it's no issue: =LOWER(CONCAT(SUBSTITUTE(SUBSTITUTE(C16342," ","."),"-",""),"@abc.com")) End result =...

I am trying to make a Data Validation list from one of my tables, but I can't seem to get the UNIQUE function to work in the Name Manager. If I create a new Name called "Sports" and use the formula =tblGear[Sport], it works just fine. However, I want the unique values from there. I don't want it...

Hi All, I am trying to perfect a formula so that I can take the first name middle initial (when present) and last name and format a certain way. John T. Doe or John Doe So far I have this formula that works when there is a middle initial present, but will leave the "Space" and "." in when...

Dear all, I am currently working on a spreadsheet that looks like this, albeit the real one is much larger: I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the...

Hi, I got a list of my employees from A1:A72, we got a game where in I need to display a single employee name without being repeated. So, that particular employee can perform the task. Or to be more exact the list is already jumbled can I display a single employee name one after the other in...

Names can either have workbook scope of worksheet scope. Excel allows you to create multiple names with the same Name property if they have different scope. So for example, I could have two names called "test" where one has workbook scope and one has worksheet scope. The problem is that if I...

Hi everyone, I am having troubles with something in Excel. I have a list of thousands of people (some with similar first and last names of course) and I have a gender column that I would like to fill out based on another table in the same worksheet that I made (see attachment name "Main...

I'm looking for some help. I started trying to use excel for this project yesterday. I originally scripted a batch file to run this operation. The batch works in a small and limited environment. I tried the batch in a live folder and it was a complete failure with files being multiplied and...

I am trying to see if there is any difference between the Name and NameLocal properties of the Name object. https://docs.microsoft.com/en-us/office/vba/api/excel.name.name https://docs.microsoft.com/en-us/office/vba/api/excel.name.namelocal If I create a name using VBA and supply both the Name...

I dont know if i just dont understand things, but as for my understandings this formular just doesnt work for me in this scenario. I want to refer to an already existing name with INDIRECT(). I want this range to end up as my dropdownlist. The name i want to refer to is called "DropDown1"...

Greetings! I created an XLAM add-in, from Excel, and it's recognized, insofar as when I start typing the name of one of its functions, Excel offers up the full name, but, then, when I attempt to use it, I get #NAME!. There's nothing wrong with the code, I'm getting an Invalid Name Error. How do...

We have a process where we end up with a workbook with formulas full of references to range names that don't exist in that workbook. As expected, the cells all show #NAME? We then move the sheets from that workbook to another workbook where those names do exist. EXAMPLE: WorkbookA has formula...

Hi! I've been using the below piece of code successfully before . . . Dim myPath As String myPath = ThisWorkbook.Path & Application.PathSeparator 'Change path If IsFileOpen(myPath & "IzborQ.xlsx") = True Then MsgBox ("File is already opened")...

Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...

I have been sent a spreadsheet which uses a custom function and all the cells are showing up as #NAME?, if I view the spreadsheet on my phone all the values are there, so they must be stored in the spreadsheet somewhere. Often I'll get a prompt asking whether I want to update values or not when...