No announcements
Found 893213 threads
-
0 VotesVBA error - runtime error 1004
Hi, when I try to run a VBA macro I get this error message: runtime error 1004 microsoft excel cannot find any data to replace. check if ...Unanswered | 2 Replies | 257 Views | Created by Ypreis - Wednesday, November 8, 2017 1:17 PM | Last reply by Ashidacchi - Thursday, November 9, 2017 1:55 AM
-
0 Votes
VBA Runtime Error 1004 “Application-defined or Object-defined error”
throws Error#1004 "Application-defined or Object-defined error". When you debug the code (F8) or run it (F5), it runs absolutely fine with out any ...Unanswered | 3 Replies | 1682 Views | Created by ravibms - Wednesday, March 11, 2015 6:34 AM | Last reply by Rod Gill - Tuesday, March 17, 2015 7:59 PM -
0 Votes
VBA Runtime Error 1004 when using MS Office 365 ProPlus
, when someone who has MS Office 365 ProPlus tries to run the same macro, they get an error: "Run-time error '1004': To copy all ...Unanswered | 4 Replies | 3434 Views | Created by hpilloud - Wednesday, October 11, 2017 3:54 PM | Last reply by Chenchen Li - Monday, October 30, 2017 9:46 AM -
0 Votes
[Excel 2k3 + VBA] Runtime error '1004' Cannot change part of a merged cell
data from access I receive this message: Runtime error '1004' Cannot change part of a merged cell and it points to this ...Answered | 3 Replies | 8598 Views | Created by Admin-Dev - Thursday, November 17, 2011 4:40 PM | Last reply by OssieMac - Thursday, November 17, 2011 11:46 PM -
0 Votes
Creating a dynamic hyperlink to a worksheet cell in Excel using VBA
hyperlink. However in testing as data goes in I get a runtime errorr "1004" application-defined or object-defined error.Answered | 6 Replies | 75518 Views | Created by Justus Beek - Friday, September 14, 2007 12:48 PM | Last reply by Justus Beek - Wednesday, September 19, 2007 7:52 AM -
0 Votes
Run Time 1004 using TreeviewControl.Drilled
Using MS Office 2010 and VBA 7.0 Getting RunTime 1004 when running the ...Unanswered | 1 Replies | 644 Views | Created by Qaspec - Thursday, April 24, 2014 11:25 PM | Last reply by OliverQueen - Friday, April 25, 2014 11:04 AM -
0 Votes
Error 1004 in Update Links
Hi there... I use the following VBA code to automatically update the links in a workbook, which is open and running 24x7. After a few updates I get ...Answered | 2 Replies | 9890 Views | Created by sarenu123 - Thursday, November 1, 2012 8:38 AM | Last reply by Leo_Gao - Friday, November 2, 2012 3:19 AM -
0 Votes
VBA function that creates a 2-D excel table
to set values using the same syntax: "cells(object.row,object.column).value=somenumber" result in a runtime 1004 error. Is there a way to do ...Discussion | 1 Replies | 4504 Views | Created by Scott14414 - Wednesday, January 12, 2011 9:33 PM | Last reply by cHARLES_wILLIAMS MVP - Thursday, January 13, 2011 8:58 AM -
0 Votes
Problem with "Save as" Marco with password protection in Excel
good. But when I click the run button, It threw me the message "runtime error 1004, method SaveAs of object _Workbook failed". How can I use ...Answered | 2 Replies | 1360 Views | Created by Isaac_SU - Friday, March 29, 2013 4:34 AM | Last reply by VBATools - Friday, March 29, 2013 6:58 PM -
0 Votes
Team foundation server 2010 Iteration backlog Capacity tab issue _ Microsoft Visual Basic Runtime error '1004' : Application defined or Object defined error
http://www.excelforum.com/excel-programming-vba-macros/832281-runtime-error-1004-application-defined-or-object-defined-error.htmlAnswered | 4 Replies | 1894 Views | Created by Tarun Raju - Tuesday, November 12, 2013 7:18 AM | Last reply by Charles-Li - Wednesday, November 20, 2013 1:34 AM -
0 Votes
Runtime error 1004 When Refreshing Pivot Tables
Also check the datasource of the pivottables. If the datasource has any change, for example, a new column is added to the dtasource table, runtime error "1004" ...Unanswered | 1 Replies | 3304 Views | Created by JRA_excel - Thursday, July 24, 2014 2:31 PM | Last reply by Caillen - Friday, July 25, 2014 6:18 AM -
0 Votes
VBA addins code Run-time error ‘424’ Object required
appClass = AppEvents When I launch excel a VBA runtime error displays Run-time error ‘424’ Object ...Answered | 3 Replies | 1721 Views | Created by dd_ - Friday, March 4, 2016 4:06 AM | Last reply by dd_ - Wednesday, March 9, 2016 4:54 AM -
0 Votes
Error 1004 in Validation.Add when string of values used as a source for Formula1 parameter contains more than 255 characters
Runtime error 1004 when my vba code tries to set up a data validation list and the source string contains more than 255 ...Unanswered | 2 Replies | 504 Views | Created by Wiz45y2i - Tuesday, March 12, 2019 11:37 AM | Last reply by Jan Karel Pieterse [MVP] - Wednesday, March 13, 2019 7:04 AM -
0 Votes
RunTime Error 1004 -Project cannot open the file
I have Rod's VBA book and cannot seem to get the ReadAllProjectData Macro to work. I get a Runtime Error 1004 - Project cannot open the ...Unanswered | 1 Replies | 3090 Views | Created by BlueAngel42 - Wednesday, February 13, 2013 8:00 PM | Last reply by BlueAngel42 - Wednesday, February 13, 2013 8:11 PM -
0 Votes
error 1004 when exporting query to excel and open picture
Runtime error 1004 FileName could not be foundUnanswered | 1 Replies | 471 Views | Created by usekar - Friday, September 21, 2018 9:22 PM | Last reply by Tom van Stiphout (MVP) - Saturday, September 22, 2018 6:16 PM -
2 Votes
VBA error 1004 in Excel 2007
On the other hand, VBA runtime error 1004 indicates a ...Answered | 3 Replies | 12711 Views | Created by Geb Blum - Sunday, June 10, 2012 8:35 PM | Last reply by Forrest Guo - Tuesday, June 12, 2012 8:51 AM -
0 Votes
External VBA Call to EXCEL Sheets.Copy method Issue
using a 3rd party product with embedded VBA to connect to MS Excel 2007. My problem is that when I call the Sheets.Copy method the code will fail with a Runtime Error ...Answered | 1 Replies | 6093 Views | Created by RSViewMan - Tuesday, February 1, 2011 11:20 PM | Last reply by Doug Robbins MVP - Wednesday, February 2, 2011 10:02 AM -
0 Votes
Migration Excel VBA 2003 to 2007: Naming a DataSeries via Link
. This works well in 2003 but in 2007 I get an runtime error 1004. NewDataSeries.Name = "=" + NewSheet.Name + "!R" + CStr(startrow) + ...Answered | 2 Replies | 5322 Views | Created by PCBachl - Thursday, July 22, 2010 11:27 AM | Last reply by PCBachl - Friday, July 23, 2010 4:36 PM -
1 Votes
run time error 1004 while updating pivot-table
Answered | 2 Replies | 7036 Views | Created by JoeNY1 - Thursday, April 10, 2014 7:07 PM | Last reply by Eugene Astafiev - Friday, April 11, 2014 9:10 AM -
0 Votes
Visual Basic Error Runtime 1004
getting is Visual Basic Runtime Error 1004: Unable to set the FormulaArray property of the range class. I have not been able to find any reference to this particular ...Unanswered | 1 Replies | 4349 Views | Created by LindseyV - Friday, September 14, 2007 4:13 PM | Last reply by Andy Pope - Saturday, September 15, 2007 9:07 AM - Items 1 to 20 of 893213 Next ›
No announcements
