+ Reply to Thread
Results 1 to 2 of 2

Error: Wrong number of argument or invalid property assignment?

  1. #1
    Mike
    Guest

    Error: Wrong number of argument or invalid property assignment?

    Hi everyone,

    I am getting the above error at the 1st line?

    Sub TTT()
    '
    ' TTT Macro
    ' Macro recorded 7/11/2006 by sultanm
    '

    '
    Range("B11").Select
    Selection.Copy
    Range("E18").Select
    ActiveSheet.Paste
    Range("E18").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = "4.22222222222222"
    Range("E19").Select
    End Sub

    Mike


  2. #2
    Tom Ogilvy
    Guest

    RE: Error: Wrong number of argument or invalid property assignment?

    You probably have created a function or sub and named it Range. You need to
    delete this function or sub.

    --
    Regards,
    Tom Ogilvy


    "Mike" wrote:

    > Hi everyone,
    >
    > I am getting the above error at the 1st line?
    >
    > Sub TTT()
    > '
    > ' TTT Macro
    > ' Macro recorded 7/11/2006 by sultanm
    > '
    >
    > '
    > Range("B11").Select
    > Selection.Copy
    > Range("E18").Select
    > ActiveSheet.Paste
    > Range("E18").Select
    > Application.CutCopyMode = False
    > ActiveCell.FormulaR1C1 = "4.22222222222222"
    > Range("E19").Select
    > End Sub
    >
    > Mike
    >
    >


+ Reply to Thread

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