+ Reply to Thread
Results 1 to 9 of 9

i am getting Compile error: Argument not optional

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    i am getting Compile error: Argument not optional

    Please Help me out
    Please Login or Register  to view this content.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: i am getting Compile error: Argument not optional

    You must get that error on this earlier line:
    Please Login or Register  to view this content.
    since Frac is a function that requires an argument and you haven't provided one.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: i am getting Compile error: Argument not optional

    please let where can because i am new for this field

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: i am getting Compile error: Argument not optional

    You've given no context whatsoever for what you're doing so it's pretty hard to assist you.

    Frac is a function that takes a string and returns a number so I have no idea why you are trying to extract parts of it. You also can't do this:
    Please Login or Register  to view this content.
    because you can't assign a value to a function, only return one from it.

  5. #5
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: i am getting Compile error: Argument not optional

    i have fractional values in Sheet3 Please help me out i am trying from this from last 2weeks

    whenever i run the macro(macro name is deci) it should convert the fractional values to decimal which is having in (attribute values1,Attribute value2,....etc)

    u can see attached my file(Sheet3)Module4
    Attached Files Attached Files

  6. #6
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: i am getting Compile error: Argument not optional

    There aren't any fractional values on sheet3. Nor are the relevant values in column C.

  7. #7
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: i am getting Compile error: Argument not optional

    i other SHeet3

    attached file
    Attached Files Attached Files

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: i am getting Compile error: Argument not optional

    Perhaps you want:
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: i am getting Compile error: Argument not optional

    yes help out

+ 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. Compile error: Argument not optional
    By lulu319 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-23-2013, 02:57 PM
  2. Compile Error: Argument not optional
    By no.18shirt in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-09-2013, 10:59 AM
  3. Argument not optional - Compile error
    By dsrfinancial in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 07:34 AM
  4. [SOLVED] Compile Error Argument Not optional
    By Bouzy210@gmail.com in forum Excel General
    Replies: 1
    Last Post: 08-16-2006, 12:05 PM
  5. [SOLVED] Compile Error: Argument not optional
    By Brett Smith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2006, 01:45 PM

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