run time error 1004

Hi In Excel 2010, under a Workbook_BeforeClose event, I have code to deselect any multiple selection of sheets. Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveSheet.Select 'removes multiple selection of sheets End Sub This works fine, when closing an individual spreadsheet...

Hello everyone i have encountered a problem with this run time error 1004 application defined error or object defined error can any one help me out of this. i have highlighted the line where the error occurred with a sad smiley please help me out Private Sub CommandButton1_Click() Dim lrow As...

Hello, I'm having a small problem with part of a code - and just dont know why it isn't working when using Private Sub Workbook_Open() whereas it works when using commandbutton()! Private Sub Execute() 'Clear All Previous Data With Sheets("Summary").Range("A3:K310") .Interior.ColorIndex =...

Hi All I've tried searching, but unable to find what the problem might be. A part of my code is returning a Run-Time error 1004 Application-defined or object-defined error and I can't figure for the life of me why. The formula, when put direct into the cell works fine, but when trying to...

I am having a Run Time Error Code 1004 pop up after making changes in the bolded line of code on the "Stage Times" sheet from: Private Sub Worksheet_Change(ByVal Target As Range) Dim xHour As String Dim xMinute As String Dim xWord As String Dim rngMonitored As Range, rng...

Hi, I am trying to run a macro to expand/collapse pivot fields whenever the pivot table is updated. Pivot table is filtered using a slicer that is connected to one of the pivot table row fields (not a pagefield). The first time I make a selection in the slicer and pivot table is filtered...

I am trying to use the regression tool from the Analysis Toolpak to run a bunch of regressions. I have everything set up and the code seems to be fine but when I try to run it I get the following error: Run-time error '1004': Cannot run the macro". The macro may not be available in this...

Hi there, I have been successfully executing the same code for quite a while, but when I attempted to run my macro this time I received a "Run Time error 1004: Select Method of Worksheet class failed" error message, and the macro bombs... What the macro is supposed to do is perform the same...

Hi guys, When I run my code I get the following error "Run-time error '1004': Application-defined or object-defined error" with this part of the code: ws4.Range("B3:CS74").Copy Destination:=ws5.Range("B3:CS74") Any help would be much appreciated :biggrin: Sub AngliaUpdate() Dim wb1 As...

I found this code and changed it to what I need. But I know I left it only half way done. I want to run my macro called Request_Form but only if either cell J2 or T61 is changed. Cells J2 and T61 are dropdown menus. When I change those cells the macro runs correctly however, when I enter...

I am having trouble with a pretty basic function. I need to copy everything in Column A (header excluded) and paste the unique values in column A in a different sheet. I chose to try to paste all of the values and then remove all of the duplicates. If there is an easier way to do this, please...

I a, a newer VBA user and I am having trouble running a Recorded and 'somewhat cleaned up' script. The following is part of what I have and Bold and Italicized is the problem part that keeps popping up with the Run time error 1004. I have tried an array of different things, but nothing has...

I have a formula that I'm using which works and gives me the right value. =COUNTIF(bommech[PO1 No],"")+COUNTIF(bomelec[Procurement Status],G4) However when I try and enter the exact same formula through VBA using, I get "Run-time error 1004: Application defined or object defined error". I...

Hi, I'm getting a runtime 1004 error: application or object defined error on the code below Seems to be in relation to "ActiveWorkbook.Connections("Database2").Refresh," Any advice appreciated. Sub Send2Access2() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim...

Daily I download a file that needs to be modified for review. When I inherited this, there was already a macro created that does this. The problem is because there are thousands of records, it takes a long time to go through it's loop. I've played with making a change in the macro that would...

Hi, I am running a macro for a results based spreadsheet and the data it imports sometimes appears on different rows. This then trips up my macro and I get the error message 'Run time error 1004: No data was selected to parse. The problem occurs when it references "Row 70" in all the lines of...

I am trying to open two different workbooks for transferring data. The name of workbooks are in two cells of the current workbook. First workbook opens correctly but there is error in opening other workbook. It says "run time error 1004. File can't be found." However, if i use path of workbook...

Okay so I have three things I need help with. 1.) I have excel 2007 and when I recorded the macro yesterday it worked just fine, but today it's coming up with the box to update values. The macro is set to open up the vendor assignment sheet and do a vlookup against the clerk and then return the...

Hi All, I having a problem with a run time error code that occurs when I attempt to copy and paste data from one worksheet to another sheet. basically I have 3 sheets 1 sheet (sheet1) is used for data entry, the op enters int various cells and textboxes by pressing a command button which...

hi all, i have two sheets which has thousand lines and i will update it daily so there will increase in line numbers day by day.. instead vlookup formula i planned to use worksheet function vlookup so that it can save time in calculating the worksheet for more than 10 mins. i tried with below...