+ Reply to Thread
Results 1 to 5 of 5

Passing 2 arguments

  1. #1
    Registered User
    Join Date
    02-03-2013
    Location
    auckland
    MS-Off Ver
    Excel 2013
    Posts
    3

    Passing 2 arguments

    When I create the following

    Please Login or Register  to view this content.
    I get a syntax error with the second argument, the first works fine

    Does anybody Know what im doing wrong ??
    Last edited by PeterMac; 07-11-2015 at 05:03 AM.

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Passing 2 arguments

    you are missing code tags. and a coma.
    Please Login or Register  to view this content.
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  3. #3
    Registered User
    Join Date
    02-03-2013
    Location
    auckland
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Passing 2 arguments

    thanks for that. It is actually when i add the second argument, and yes i forgot the comma here as I recreate the problem

  4. #4
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: Passing 2 arguments

    carefull cause you are going to delete (clear) a column not a row:
    Please Login or Register  to view this content.
    for me it works if I call the sub with the Call statement:

    Please Login or Register  to view this content.

    if you want to delete rows use:
    Please Login or Register  to view this content.
    Last edited by bulina2k; 07-11-2015 at 05:26 AM. Reason: Sub / Function

  5. #5
    Registered User
    Join Date
    02-03-2013
    Location
    auckland
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Passing 2 arguments

    Call was the problem - thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Passing arguments in Range()
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2013, 11:12 AM
  2. Passing arguments?
    By RPhilbin83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2011, 09:29 AM
  3. Passing Arguments
    By cosmarchy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2010, 04:36 PM
  4. Passing Arguments Between Spreadsheets
    By nt180792 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2009, 02:26 PM
  5. [SOLVED] Passing arguments from VBA to DLL
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-18-2006, 04:15 AM

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