error 1004

Hi all, I have a problem making my program open on a specific worksheet, as I get a 1004 error and the text "Method activation of class Worksheet error". This only happens when I put my code in a Workbook_Open sub like this: Sub Workbook_Open() With Application .DisplayFullScreen = True...

Hi all, so I am trying to resize the selection to equal a number of rows and columns specified in cells C45 and C46, respectively. My code gives me a 1004 Object Orientated error. Does anyone know how to fix this? Sub TableExpand() Worksheets("Sheet1").Activate numrows =...

Hello everyone I'm currently having some issues when trying to delete multiple columns in a worksheet, it shows "Error 1004", and stops the macro. But when I press F8 after the editor highlights that line of code, it works fine and deletes the columns... Every time I try to do this in the...

Hey All . . . I have used this code before, grabbed it from here (good stuff if you use SSRS):Chintak's Blog - Refreshable SSRS reports in Excel - Chintak Chhapia , and it has always worked swimmingly. I have another use case that requires this trick, but I am repeatedly getting a paste error...

Hi guys. I have been facing an error 1004 on my code to copy and paste a particular range everytime a specific cell is changed.Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo tratamento ' Application.ScreenUpdating = False Dim KeyCells As Range Set KeyCells =...

Hello, I am facing run time errors 1004 with this piece of code. It is strange because this code worked in another module, but when I placed this in a userform sheet, it doesn't work. VB: Dim FileName As String Dim SummarySheet As Worksheet Dim WorkBk As Workbook Dim FolderPath As...

Hi, I am trying to write a code which will loop through all excel workbooks in a particular folder & copy data from a specific tab on each sheet and then paste it to a master excel workbook. I have got the code to select folder, extension, tabname basis inputs from user and also loop thru...

Hello I am kind of new in VB and I am trying to control different pivot tables with a combobox, but when I try to do so I receieve the same error that says: "Error 1004: Application-defined or Object-defined Error". This is the code that I am using. Could someone help me to solve this issue? Sub...

Hi, I am new to VB coding and deperately need help... I have racked my brain but cant find the cause of error 1004 with this particualr line (highlighted in Red). Dim X as Long Dim iRow, iCol, intMonths As Integer iRow = X * intMonths 'X is the number of rows in Sheet1 with data iCol =...

I hope my favorite community can help me with a VBA problem that has been stumping me. I have a VBA macro where I want to insert a VLOOKUP formula into a cell. Sounds easy right? However, the workbook I am going to perform the lookup on is different that the one where the macro resides and I...

Hello all, I just got introduced to VBA and am trying my first steps in it. I have data in 3 consecutive rows (let's say A1:E3) and every 3 rows of data, I want to move that "block" --> two cells to the right. So basically, I have: A1 B1 C1 D1 E1 A2 B2 C2 D2 E2 A3 B3 C3 D3 E3 That want to...

Hi Friends, I´ve searching all across Google but haven´t found a solution yet. :geek: I have a workbook with a number of sheets (my projects). They increase and decrease based on my business demands. I´m trying to consolidate 1 column of data for each sheet in one single sheet, in the same...

Hi, I have been receiving a Run-time error 1004 "Application-defined or object-defined error". I have been reading threads for a about a week with no luck. Please help! This is the code and the line with the error is bolded below. The purpose is to have it loop through the column and find...

Hello, everyone! This is my first post here, because it's the first time I did not find a satisfactory answer to an issue... The problem is, I have a file with 21 sheets, each one has 3 or 4 pivot tables; all pivot tables INSIDE A SHEET connect to a specific data source (which is a range in...

Hi All,<o:p></o:p> <o:p></o:p> I am using this autofill code for my macro.<o:p></o:p> <o:p> </o:p> Sheets("Data").Select<o:p></o:p> 'This counts the # of Rows in the Coulmn A<o:p></o:p> IngoMaxRo = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row<o:p></o:p> <o:p> </o:p><o:p>...

Hi everyone, Recently I have started recording and editing macros. I am really new in this field and I am not able to find the solution for one of the latest macros I have recorded. When I run the macro below I get the following error message: Run-Time error '1004': Method...

Hello all, I am trying to automate a report to send tables via outlook. I am summarizing the data in a Pivot however I am getting an error as soon as it starts the first loop. I think is may be some kind of sheet naming or activation error but I'm really not sure any ideas? I've bolded the...

Hey guys.. So i'm attempting to do a VLOOKUP on a list of names, the Lookup_Value being pulled from an added worksheet and the Lookup_Range being on a Master sheet (both within the same workbook) The code works perfect when the VLOOKUP returns a value, but when returning the error '1004', it...

I am getting the reference pop up when running this code. Please help! Sub Agent1_Change() Dim ChartType As String Application.EnableEvents = False Application.ScreenUpdating = False With ActiveSheet.PivotTables("Actual1").PivotFields("Leasing Agent").CurrentPage = ClearAllFilters...

Hi there, I’ve been using the below code for some time to delete unwanted (grand total) rows from an often updated document: Sub DeleteRows() Dim InputRng As Range Dim DeleteRng As Range Dim DeleteStr As String Dim rng As Range, cell As Range, del As Range Set rng =...