run-time error '1004

  1. A

    Form data transfer Error "Run-Time Error 1004 Application defined or object defined error"

    Hello all, VBA newbie here been reading thread after thread trying to solve the Run time error 1004 Applicatin-Defined or Object-defined error. Eveything i can see looks correct. I'm not sure what im missing in this data Entry Form. I keep getting stuck on the following Code: nextRow =...
  2. W

    Call a Macro from another workbook

    Hi there - just wondered whether someone could help me as my brain is currently fried .. I have a workbook named KPI_DASH. This collates data collected from various other workbooks i.e BookA. The KPI_DASH workbook is hidden to the user and they wouldn't open it. Within KPI_DASH is this...
  3. V

    Naming worksheet based on value in cell...ERROR message

    Hi, I am trying to rename my worksheets (540 of them) based on the value in cell A200 (which is a formula pulling together 3 cells, so =A1&" "&B1&" "&A3 ). I've checked all the sheets to make sure there is a value in cell A200. However, when I run the below macro, I get a Run-time error...
  4. L

    Using VBA to insert a dynamic variable formula ERROR

    Good afternoon, This is my first time posting a question on this thread but have seen many How To for my Excel projects. I've been using Excel for over 10+ years and VBA about 3 so it's not too often I come across something I cant figure out. I am trying to insert a variable formula nested...
  5. B

    Run-time error '1004': while trying to p_rint out

    Run-time error '1004': while trying to printI have created a user form were I select certain checkboxes for the sheets I want to print and then run the code below to print. If possible could someone take a look and see what I need to correct to fix this problem? Thanks for the help as always...
  6. N

    Copy/PasteValues Run-time error '1004': Application-defined or object-defined error

    Hi! Working on a code to convert a part of a sheet into a CSV file: Problem is that I get "Run-time error '1004': Application-defined or object-defined error" when running it, stopping at "ActiveSheet.PasteSpecial Paste:=xlPasteValues". Any help? :) Sub ProdCSV()...
  7. C

    Run-time Error '1004': Method 'Cells' of Object '_Global' failed

    I have excel based calculation model which interfaces with 6 other excel sheets. However, if i save all the files when i close the model, i get subject error for the following code. Not able to track what is the issue. Model usually jumps at code line starting wb2.activeworkbook..... OR at...

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