name

  1. D

    Macro move file to existing folder by name using filename first left7 digits with a space delimiter

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

    Are Name.Name and Name.NameLocal the same?

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

    INDIRECT doesnt work properly

    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"...
  4. UniMord

    Installed XLAM, Functions Not Recognized

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

    bulk re-enter formulas in cell to fix #NAME? error

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

    Ambiguous name detected error

    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")...
  7. D

    Run-time error "53": File not found - How to fix?

    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)...
  8. bigturnip

    Is there anyway to open a workbook witout updating contents?

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

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 MrExcel.com.
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 "mrexcel.com".
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
Top