+ Reply to Thread
Results 1 to 3 of 3

Editing multiple cells error - runtime error 13 and 1004

  1. #1
    Registered User
    Join Date
    09-16-2019
    Location
    Philippines
    MS-Off Ver
    365
    Posts
    29

    Editing multiple cells error - runtime error 13 and 1004

    I have an excel file with the VBA code below to automate some columns for date and stuff.

    It works if I am editing just one cell at a time. If I edit multiple cells (copying & pasting in multiple cells/range or deleting a row), these are the errors I get.

    - Run-time error '13' - Mismatch
    - Run-time error '1004' - Application-defined or object-defined error


    HTML Code: 
    Attached Files Attached Files
    Last edited by mia12; 09-01-2021 at 04:40 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Editing multiple cells error - runtime error 13 and 1004

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Target.Column = 2 And Target.Offset(0, 1).Value = "" Then
    Target.Offset(0, 1) = Format(Now(), "")

    End If

    If Not Intersect(Target, Range("D:D")) Is Nothing Then
    Target.Offset(0, 1) = Now

    End If

    End Sub
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-16-2019
    Location
    Philippines
    MS-Off Ver
    365
    Posts
    29

    Re: Editing multiple cells error - runtime error 13 and 1004

    Thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA error: runtime error 1004 : Method range of object - 'Global' failed.
    By Afjio12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2019, 04:37 AM
  2. [SOLVED] runtime error 1004 - using a single macro for multiple reports
    By sschroe954 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-09-2015, 06:30 PM
  3. Runtime error '1004': Paste special method of range class error.
    By Daryl Zer0 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2014, 01:44 AM
  4. [SOLVED] VBA Error: Runtime Error 1004: AutoFilter method of Range class failed
    By jl22stac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2013, 07:27 PM
  5. Need to Create Error Message Box during Runtime error 1004
    By ExcelHelp2013 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2013, 06:24 AM
  6. [SOLVED] Range error in code, runs alone but not inside my full program, giving runtime error 1004
    By charizzardd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 03:34 PM
  7. [SOLVED] Excel 2003 Macro Error - Runtime error 1004
    By Cow in forum Excel General
    Replies: 2
    Last Post: 06-07-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1