error 2023

  1. N

    INDEX Function gives #REF! Error on worksheet and Error 2023 in UDF

    I am not sure what is causing below error, it seems my mind has stopped thinking ... it's been a long day. Wrapping below FORMULA in a SUM function gives me #REF error in excel. The formula with SUM is in cell E4. INDEX(A:C,ROW()) The column reference is omitted as I want it to return all 4...
  2. H

    Error 13 Type Mismatch and Error 2023 on cell

    Hi, I am trying to make a macro that groups up rows and sums the amount of items that they have on a column, I made it so it works but after a few rows it just crashes and displays Error 13: Type mismatch. When I open the code it highlights this line The code is this one: I can't come up with...
  3. Ruddles

    DDE to MS Access: DDEPoke not working (Error 2023)

    I'm using Access as a DDE server. If I do this, everything works fine:- Sub Test1() Dim iChannel1 As Integer Dim iChannel2 As Integer Dim sSQL As String Dim vData As Variant Shell "MSAccess " & dbPath & "database1.mdb", vbMinimizedNoFocus iChannel1 =...

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
Back
Top