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