run time error '1004'

Hi team, down below is the code that runs on WB open. Every time I open that Workbook I am getting a Run-time error '1004'. What could be the cause? Thank you for help. Private Sub Workbook_Open() With Application .ScreenUpdating = False: .WindowState = xlMaximized: .DisplayStatusBar =...

The following code, which works in other macros, is causing a “Run-time error ‘1004’: Application-defined or object-defined error" Cells(20000,1).Select Selection.End(x1Up).Select Let lastrow = Activecell.Row The debugger is highlighting row 2 -- the equivalent of a manual “end then up...

Good morning incredible excel people! ? I hope you’re all going well this sunny weekend. I was just wondering if someone might be able to help point me in the right direction or if you have any ideas that would be greatly appreciated. I have the below module that takes two sheets and inserts...

Sub GetSheets() ' Write in the specific path where the file is saved in the path Path = "D:jjjjj\Report 2019-20\" Filename = Dir(Path & "*.xls") Do While Filename <> "" Workbooks.Open Filename:=Path & Filename, ReadOnly:=True For Each Sheet In ActiveWorkbook.Sheets Sheet.Copy...

Hi All Sub concatenate() Dim a As String: a = "L:\OWL\Work" Dim b As String: b = "\jobs" Dim c As String Dim d As String c = Cells(0, 3).Value d = a & c & b Worksheets("sheet 2").Cells(1, 5).Value = d End Sub

I have some VBA that has worked in the past without a problem but will not run anymore. The VBA deletes all the sheets in a workbook that are not listed. If searched the forums and there are several posts that suggest replacing "Sheets" with "Worksheets", but this did not work for me. The error...

I 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 Here is the code I have Private Sub...

Hi all I am getting the following runtime error when trying to run a specific code to delete columns, any help would be appreciated. I am not sure what is going wrong here. ERROR Run-time error '1004': Delete method of Range class failed CODE Sub Delete_Column()...