Application-defined Or Object-defined Error Querytable
Contents |
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired application defined or object defined error excel content Samples We’re sorry. The content you requested has been removed. You’ll be
Application Defined Or Object Defined Error Access
auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads application defined or object defined error 32809 Remove From My Forums Asked by: Run-Time error '1004': Application-defined or object-defined error (Editing a data checking workbook I did not create) Microsoft ISV Community Center > Visual Basic for Applications (VBA) Question application defined or object defined error in macro 0 Sign in to vote PLEASE HELP ME, I have a deadline I need to meet tomorrow and in order to complete my work I need to use this 'data checking' sheet that I am not familiar with (please note I am a total newby at VBA so please be kind). I made the changes I needed to and then when I hit the Macro button
Application Defined Or Object Defined Error In Vba
I recieved "Run-Time error '1004': Application-defined or object-defined error". When I select Debug it takes me to VBA and this is what I can see: Private Sub btnRefresh_Click() Application.ScreenUpdating = False Sheets("AM").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("PM").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("Peaks").Select End Sub Private Sub btnRefresh_Links2_Click() On Error Resume Next Range("A1").Select ActiveWorkbook.UpdateLink Name:= _ "P:\PSG NA Common Folder\OTR 2011 - 2012\2011_12 Worksheet.xls", Type:= _ xlExcelLinks End Sub Private Sub btnRefresh2_Click() Application.ScreenUpdating = False Sheets("AM Contra").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("PM Contra").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("Off Peak").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("Weekend").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("DTP").Select Selection.QueryTable.Refresh BackgroundQuery:=False Sheets("Other Periods").Select End Sub The line "Selection.QueryTable.Refresh BackgroundQuery:=False" is highlighted in yellow, which makes sense because that is the worksheet that I made changes to..... but now how do I fix the problem? I have NO IDEA how to use VBA - can anyone help?!?!?!?! Wednesday, February 13, 2013 6:34 AM Reply | Quote All replies 1 Sign in to vote This seems that the query is depending on external data source.I assume you did not change/remove anything there. Change the Activecell of all sheets.
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 23:13:54 GMT by s_hv987 (squid/3.5.20)
Forums Excel Questions Error 1004 Application defined or object defined error Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 14 Error 1004 Application defined or object defined http://www.mrexcel.com/forum/excel-questions/68044-error-1004-application-defined-object-defined-error.html errorThis is a discussion on Error 1004 Application defined or object defined error within the Excel Questions forums, part of the Question Forums category; I must be getting old. I have a userform setup to enter data into a worksheet Whee the user hits ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable defined or Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Dec 1st, 2003,10:12 AM #1 Peter Rouse New Member Join Date Feb 2002 Posts 14 Error 1004 Application defined or object defined error I must be getting old. I have a userform setup to enter data into a worksheet Whee the user hits the button to add the data, I get the error 1004 Application defined or defined or object Object defined error It is on the line Set LastRow Private Sub CommandButton1_Click() Dim LastRow As Object Set LastRow = Sheet1.Range("a65536").End(x1Up) ....end sub Now I am sure this has always worked in the past, so Is it me or am I really missing a plank or two? Thanks Peter Thanks Peter Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 1st, 2003,10:36 AM #2 Joe4 MrExcel MVPModerator Join Date Aug 2002 Posts 34,558 Re: Error 1004 Application defined or object defined error It should be: Set LastRow = Sheet1.Range("a65536").End(xlUp) not Set LastRow = Sheet1.Range("a65536").End(x1Up) Share Share this post on Digg Del.icio.us Technorati Twitter TIPS FOR FINDING EXCEL SOLUTIONS 1. Use the built-in Help that comes with Excel/Access 2. Use the Search functionality on this board 3. A lot of VBA code can be acquired by using the Macro Recorder. "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!" Reply With Quote Dec 1st, 2003,10:45 AM #3 Peter Rouse New Member Join Date Feb 2002 Posts 14 Re: Error 1004 Application defined or object defined error Thanks jmiskey, I just knew it was somehting I had done, but kept looking