Results 1 to 14 of 14

Error code : Application-defined or object-defined error ?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-08-2021
    Location
    thailand
    MS-Off Ver
    2016
    Posts
    117

    Error code : Application-defined or object-defined error ?

    Now I have macro as below.


    Sub test546()
        Dim a As Variant
        Dim i As Long
        a = Cells(2, 2).Resize(Cells(Rows.Count, 4).End(xlUp).Row, 4)
        For i = 1 To UBound(a): a(i, 1) = "=" & a(i, 4) & "/" & a(i, 3): Next
        Cells(2, 6).Resize(UBound(a)) = a
    End Sub
    But after run , it show error Application-defined or object-defined error in line Cells(2, 6).Resize(UBound(a)) = a


    Please guide me about it.
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. HELP WITH ERROR CODE '1004' Application-defined or object defined error
    By QuintonMcCloud in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-20-2015, 03:34 PM
  2. VBA ERROR: run time error 1004: Application-defined or Object-defined error in excel 2013
    By AnanthKrishna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2015, 06:16 AM
  3. Previously working code is now is now giving Application-defined or object-defined error
    By ready2learn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2014, 07:22 PM
  4. [SOLVED] VBA Application-defined or Object-defined error on an unknown line of code.
    By kyleg222 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2012, 10:19 AM
  5. Pivot Cache VBA code - Application-defined or Object Defined error
    By 4am in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2011, 02:21 PM
  6. [SOLVED] Application-Defined or Object-Defined Error on simple code
    By Fid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2005, 04:05 PM
  7. [SOLVED] Application-Defined or Object-Defined Error on simple code
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2005, 05:06 PM

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