run-time error 1004

Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Sheet1.ShowAllData On Error GoTo 0 Dim fromRow% Dim archiveRow% Dim strMatch As String Dim wsTarget As Worksheet 'sheet to move data to Dim blnMove As Boolean 'whether to move data or not Dim...

I wrote a macro AutoPing() that allows to loop itself every 5 minutes. It works between before 23:50. But it gets error when it passes to next day (00:00). Please help me solve this error. Thank you.

Hello, I am in the process of transferring a lot of the sheet calculations and conditional formatting into vba for efficiency and in the process I am receiving an error that I cannot seem to figure out, "run-time error 1004; method range of object worksheet failed". I have attached all the...

Hi ya'll, first time poster here! I've been struggling for a few days on making this work. Context: I have a sheet called 'Imported Data' that contains thousands of rows of data & 15 columns. It will always contain the same 15 columns - the data comes from a | delimited text file. Through other...

I have been running this code successfully, for a while now. For some reason it just started throwing this error code: Run-time error '1004': Method 'Range' of object'_Global' failed Sub New_Associate() Dim NextRow As Range Set NextRow = Range("A1" & Sheets("Helper").UsedRange.Rows.Count...

Is there something wrong with my code? Please help! "Sheets("Web Query").Columns(10).Copy Destination:=Sheets("Tracker").Range("A1")" - This is a working code but I want the copied data start at Range("A5") or Columns.(1, 5) "Sheets("Web Query").Columns(10).Copy...

Dear all, I would like to solve a set of linear equations with VBA. I need to do this with VBA, because the number of equations is dynamic. While executing I get the error as metioned in the title and the last line is highlighted. I read a lot about the error, but I couldn't find my mistake...

I created a Macros for a spreasheet that works wonderfully up until it saves. It works just fine on my PC but when someone trys to run it on another Networked PC it bug's out at the place in red below: Dim dtDate As Date dtDate = Date Dim strFile As String strFile...

I want to save an excel file. -The file’s name and folders’s names will change each time a file is saved. -I recorded a macro to save the current file, then added variables defined by InputBoxes so a user could name and save each file to the correct folder.</SPAN> I get the error message...

Hello, I am using below code to export Salary Payslip as PDF but i am getting below error while exporting. after export few Page, i am getting "Run-Time error 1004" (Document not Saved. The Document may be open, or error may have been encountered when saving). Code is below Option Explicit...

Hi all. I cannot understand what is wrong here. Dim Counter As Long Dim Counter2 As Long Dim AssociateList As Range 'Check Number of Lines with Reports Filled Counter = 1 Do Until ThisWorkbook.Sheets("Tracker").Cells(Counter, 2).Value = "" Counter = Counter + 1 Loop 'Check Number of...

I've been using the following Mac Excel Office 2008 macro SUCCESSFULLY (for years): Sub Auto_Open() With ActiveWorkbook .SaveCopyAs .FullName & ".Backup:" & Format(Now, "YYYY_MM_DD_HH_MM_SS") End With End Sub to save a backup copy in the files' parent directory in a filename.backup...

Howdy folks, I've been working on this problem for quite a while, and I can't get it to work properly. I am creating a macro for someone where data is consolidated from multiple worksheets into two summary sheets. From there, based on options selected on a "setup" worksheet, multiple...