-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
run-time error '1004
-
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 =...- AWood4081
- Thread
- run-time error '1004 vba & excel
- Replies: 4
- Forum: Excel Questions
-
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...- wizard94
- Thread
- application.run end kpi_dash run-time error '1004 workbook
- Replies: 4
- Forum: Excel Questions
-
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...- vik2slick
- Thread
- cell error naming worksheet run-time run-time error '1004
- Replies: 7
- Forum: Excel Questions
-
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...- lwarren30
- Thread
- autofill cellsfindcode.row do loop formula and vba insert run-time error '1004 userform vba
- Replies: 19
- Forum: Excel Questions
-
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...- bamaisgreat
- Thread
- code copies end run-time error '1004 true
- Replies: 2
- Forum: Excel Questions
-
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()...- N00bTube
- Thread
- application-defined error copy & past run-time error '1004
- Replies: 2
- Forum: Excel Questions
-
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...- c2shar
- Thread
- run-time error '1004
- Replies: 2
- Forum: Excel Questions
