error

XERROR.TYPE displays the XTYPE-style error type or error name for all Excel errors XERROR.TYPE takes three parameters, one requires, and two optional, as follows: A) The first parameter, required, specifies the input and can be a single cell, range, or array. B) The second parameter, optional...

I ran into this problem before, and don't remember how it was resolved! I'm getting this error: And no, it is not because the name starts with an underscore or because the parameter is bracketed because it's optional I have no doubt it's something dumb. Could be me!

Hello, a few of my collegues use a macro that is in their Personal workbook and connected to a custom button in their quick access ribbon. Suddenly they are getting an error pop up that it couldn't find their Personal workbook (asking "is it possible it was moved, renamed or deleted") - but it...

Hi All, I have a excel where I have made some Macros, Power query and formulas. not sure what is causing this error but I'm unable to save it, it used to work well before :( any suggestions please? Thanks

MATCHES is a powerful enhancement to the Excel's built-in MATCH function and returns the relative positions of all items in a one-dimensional array that match a specified value Excel's built-in MATCH function returns the relative position of the first matching item in a one-dimensional array...

ISXTYPE, companion to XTYPE, is a powerful alternative to Excel's built-in type-based conditional functions such as ISNUMBER, ISTEXT, etc., while packing other useful features as well ISXTYPE was designed to provide conditional output after assessing the precise and high-resolution data type of...

XTYPE outputs the precise data type of a cell/range or the elements of an array beyond the resolution of Excel's TYPE() or CELL("type",) XTYPE was designed to provide detailed and high-resolution information about the data type that a cell or cells of a range/array contain. Thus, it is...

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

Working on Excel VBA app. And I am getting an error I can not figure out. The app is displaying a range from a spreadsheet in a list box on a user form, The first time it does this, things work fine. The user form has some text input boxes that allows the user to input a new row of data unto...

Version: Excel Online I want an average of the time (in days) between two milestones for many different people (one person per row), but I want the formula to ignore that row if there isn't a date in BOTH date cells, since it throws off the average in a major way. Example "TABLE_1" EE Name...

I'm using the below code to bring up the file dialog box so the user can select a file path to save a file. What I want to do is stop an error from occuring when the user clicks the 'Cancel' button in the dialog box. Currently when you click 'Cancel', it comes up with 'Run-time error '5'...

Hello All, I tried to do a loop that would write an entry to an error log sheet in the event a folder couldn't be created or already existed, but I haven't done it well, and continue to endlessly generate errors. If someone has any insight into where I went wrong, or suggestions on a more...

Hi, this is the vlookup I currently have (that works) VLOOKUP(F2,'\\documents\August\[File Name 30.08.22.xlsm]Sheet 1'!$F:$Z,21,0) The issue is that everyday I have to reset the formula with the prior working day so that it's pulling through the latest comments. I'm trying to create a static...

My code below: Sub arrange() 'all declarations for wkshts and wbs stated at top unless stated here Dim g1 As Range Dim g2 As Range Dim g3 As Range Dim g4 As Range Dim g5 As Range Dim g6 As Range Dim g7 As Range Dim g8 As Range Dim g9 As Range Dim g10 As Range Dim g11 As Range Dim g12 As Range...

I am unsurea bout why htis is not working and giving me a type missmatch error Private Sub SubmitCSR_Click() Dim LastRow As Long Dim ws As Worksheet: Set ws = Sheets("GP count") 'declare a variant array Dim ReceivedV(1 To 6) As String 'populate the array ReceivedV(1) =...

Hey All, I'm getting the error that no cells have been found when running the following code. Although it is correct and no cells have been found under the criteria I've put, I want the code to just move on and continue with the code. Could anyone help me to do this? I am a beginner when it...

Hi This has flummoxed me. I have attached two images showing how the address details are displayed in the cells, and how they are displayed in the drop down preview section. As you can see there is the odd square symbol representing a line break in the main cell section and the line break in...

I’m getting this error to populate my worksheet from another software provided by my company. Can you help me solve this?

Hi All, Got another issue but this time pertaining to an Expression Error which I cant quite figure out. The workbook that I'm working on is connected to Dynamics 365 where a separate tab showing all the data has been created. I have built the data entry and and pivots around the fields that...

I have a table with several columns as shown below. The issue is that I must do a search for a number entered manually. The search must be done in a column that results from multiplying the value $ by 100. With some values, inexplicably, the result of the formula +MATCH(I;$H$4:$H $164;0 ) is...