error in code

  1. P

    Error in code

    I typed the following command: DoCmd.GoToRecord acDataForm, Me.Parent, acNewRec I am getting the following error: Runtime error ‘2498’: An expression you entered is the wrong data type for one of the arguments.
  2. L

    Error Message - Text file opened on Excel

    My intention is to open a txt file in Excel, do text-to-column separation, then copy the data and paste on a template workbook the macro opens. The following macro does well upto parsing the data, but fails at copying the data. I get error message when it gets to that point. Two questions, how...

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