Results 1 to 3 of 3

Objetct Required error; Please help

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    402

    Post Objetct Required error; Please help

    I am using the following code to run a macro.
    It runs fine but at last I get the error code as Object Required.
    Please help me in fixing it.
    Sub PALL()
    'copia linha inteira com criterio
        Dim i As Range
        For Each i In Range("L1:L50000")
            If i.Value = "Ajay Kumar Deshmukh 10170226" Or i.Value = "Satish Kumar Karike 10172480" Or i.Value = "Sandeep Tekam 10172475" Or i.Value = "Makhan Rahul Singh 10170896" Or i.Value = "Abdul Muqtader Mohammed 10170254" Or i.Value = "Nagendra Kumar 10170887" Or i.Value = "Naveen Mandula 10170251" Or i.Value = "Waseem Mohammed 10169733" Or i.Value = "Rozeena Pirani 10172290" Or i.Value = "Prabhat R. 10171905" Or i.Value = "Avinash Barua 10171903" Or i.Value = "Prajesh Jena 10172473" Or i.Value = "Prabhat Kumar Rao 10171905" Then
                i.Select
                ActiveCell.Rows("1:1").EntireRow.Select
                Selection.Copy
                Sheets("PVlookup").Range("A65000").End(xlUp).Offset(1, 0).PasteSpecial
            End If
        Next i
    End Sub
    Last edited by kishoremcp; 01-25-2012 at 03:56 PM.

Thread Information

Users Browsing this Thread

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

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