error1004

  1. T

    Excel vba export csv to onedrive works perfectly on my machine but not on clients who has share

    I desperately hope someone can help.I have some simple VBA code that makes a copy of a worksheet and saves it to a shared folder on Business OneDrive, the main bit of code is just: Sheets("Data").Select Sheets("Data").Copy ActiveWorkbook.SaveAs Filename:="https:// blah /bla". ...
  2. J

    Error Creating Pivot Table

    Well, I'm trying to create a pivot table from raw data on a weekly report (technically, a co-worker is, and I'm trying to help them debug the macro). Everything seems to be reformatting on the source report correctly, but the problem happens when I'm creating the pivot table. I'm sharing the...
  3. J

    date today formula 1004 error in vba

    Columns("U:U").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("U1").Value = "Data" Range("U2").Select ActiveCell.FormulaR1C1 = "=DATE(Month(TODAY())&Date(TODAY()-20)& &LOW&L2&_INV&S2" Selection.AutoFill...
  4. A

    Macro auto fill is not workin

    Hi all I am trying to write for my excel .I am begginer and this first time I tred Macro. I wrote this code <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit;">Private Sub Worksheet_Change(ByVal Target As Range) If Application.Worksheets("1").Range("D2").Value...

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