+ Reply to Thread
Results 1 to 6 of 6

Compile Error: Wrong number of arguments or invalid property assignment Error

  1. 04-22-2016, 02:05 PM #1
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    991

    Compile Error: Wrong number of arguments or invalid property assignment Error

    Any suggestions

    John
    Attached Images Attached Images
    Last edited by JJFletcher; 04-22-2016 at 02:29 PM.
    Reply With QuoteRegister To Reply
  2. 04-22-2016, 02:16 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,223

    Re: Compile Error: Wrong number of arguments or invalid property assignment Error

    This code worked for me. Can you please attach the entire file?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 04-22-2016, 02:20 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Compile Error: Wrong number of arguments or invalid property assignment Error

    Do you have a procedure named Range somewhere? Bad idea ...
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  4. 04-22-2016, 02:23 PM #4
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    991

    Re: Compile Error: Wrong number of arguments or invalid property assignment Error

    By selecting the rest button - Top I get the error.....
    Last edited by JJFletcher; 04-22-2016 at 02:27 PM.
    Reply With QuoteRegister To Reply
  5. 04-22-2016, 02:39 PM #5
    JJFletcher
    JJFletcher is offline
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    991

    Re: Compile Error: Wrong number of arguments or invalid property assignment Error

    Thanks shg... making the comment you did - I reviewed and made the modifications needed and now all is good.

    Excellent -= Thanks Much!

    John
    Reply With QuoteRegister To Reply
  6. 04-22-2016, 05:29 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Compile Error: Wrong number of arguments or invalid property assignment Error

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Getting compile error 'Wrong number of argument or invalid property assignment'
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-17-2014, 07:50 AM
  2. [SOLVED] wrong number of arguments invalid or property assignment error
    By uduyt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2013, 07:40 PM
  3. Compile Error: Wrong number of arguments or invalid property assignment .... help!
    By powercell99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 03:30 PM
  4. [SOLVED] Compile Error: Wrong number of arguments or invalid property assignment
    By bobmaucher in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2013, 12:41 PM
  5. wrong number of arguments invalid or property assignment error
    By uduyt in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2012, 08:39 AM
  6. Code error “wrong number of arguments or invalid property assignment”
    By hattrick_123a in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2011, 06:16 PM
  7. Error message: Compile error: Wrong number of arguments or invalid property assignment
    By Snoopy in forum Excel General
    Replies: 1
    Last Post: 02-17-2006, 12:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1