+ Reply to Thread
Results 1 to 2 of 2

Macro returning Error Message

Hybrid View

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    Perth,Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Angry Macro returning Error Message

    I now have a problem when writing even a simple Macro eg
    Sub Unit2()
    '
    ' Unit2 Macro
    '

    '
    Sheets("Units").Select
    range("A1").Select
    End Sub
    I get Compilation Error
    Wrong number of arguments or Invalid Property Assignment

    It appears to only happen in one workbook, as the same macro takes me to Cell A! in a sheet called "Units"

    Can anyone make some suggestions as I have nearly finished the whole workbook, and this is stuffing me up.
    Last edited by Pbraun1; 02-01-2012 at 05:24 AM. Reason: No Tags

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Macro returning Error Message

    Hi Pbraun1
    Unfortunately,

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

    Please PM when you have done this and I will delete this post
    If you have any problems let me know and I can help add them.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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