Results 1 to 3 of 3

Thread: Getting Runtime error 1004: Application Defined or object defined error

Threaded View

  1. Oct 1st, 2012, 10:27 AM #3
    soniamalhotra
    soniamalhotra is offline

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    3

    Re: Getting Runtime error 1004: Application Defined or object defined error

    I did debugging, and for rng.value it is giving me proper count.
    I checked rng.Rows.Count values -- this is also correct and for rng.Columns.Count - its value also correct.
    I think error is in trg.Cells(65536, 1).End(xlUp).Offset(1)

    It is copying till 14th row and then i t copied values for first 3 columns and then it stopped.

    is there any better way to use other than this expression.
    Last edited by soniamalhotra; Oct 1st, 2012 at 10:29 AM. Reason: adding more commetns
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width