+ Reply to Thread
Results 1 to 4 of 4

function returning blank on running

  1. #1
    Registered User
    Join Date
    11-29-2020
    Location
    india
    MS-Off Ver
    2021
    Posts
    92

    function returning blank on running

    I have cell H1 with certain values as "10,1,7,8" dynamically, another cell A1 calls the function as =FindGrade(H1,"Books")...when the values of e.g B is string like "2,11" then it shud check for both 2 and 11 existing in the cell H1 value also but its not working...the result cell is blank... I m trying to get result of function into cell but the cell is always blank

    idea is to check the string in chkcell with each value in A,B,C,D etc and generate the new value called Result and populate the A1 with it.

    my code is
    Please Login or Register  to view this content.
    in A1 i want it to be "A2" its shud check 10,1,7,8 first with each values in A,B,C,D1,D2,D3 generate the string...in this case it ill be A2

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: function returning blank on running

    You have this line of code
    Please Login or Register  to view this content.
    but you have not passed chkevent to the function, you pass it Eventtype.

    If you put Option Explicit at the top of the module, you'd probably get a compile error as the variable is not defined.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    11-29-2020
    Location
    india
    MS-Off Ver
    2021
    Posts
    92

    Re: function returning blank on running

    ok i corrected the chkevent ....but still its not working

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: function returning blank on running

    Please post a sample workbook. See the yellow banner at the top of the page.

+ 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. Stop INDIRECT function returning a 0 if cell is blank?
    By Belinea2010 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2021, 10:39 AM
  2. [SOLVED] running a function with multiple variables left blank
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2016, 04:03 PM
  3. [SOLVED] IF function returning blank cells as 0 instead of a blank even though "" is being used
    By scootty83 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 06-02-2015, 02:47 AM
  4. [SOLVED] If function returning incorrect value reference cell value is blank
    By lbrannon in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-23-2013, 09:40 AM
  5. [SOLVED] Excel function is returning undesired answer for blank cells
    By dcwandj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-28-2012, 12:14 PM
  6. Replies: 5
    Last Post: 12-02-2009, 08:02 AM
  7. returning blank cells in an IF function
    By Squeky in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2006, 10:00 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