+ Reply to Thread
Results 1 to 2 of 2

VB Color Function Error

  1. #1
    Registered User
    Join Date
    01-31-2013
    Location
    St. Louis
    MS-Off Ver
    Excel 2010
    Posts
    4

    VB Color Function Error

    This forum helped me with an issue last year. I'm attaching an excel spreadsheet of student data.

    On worksheet 8GT2J1314 --> the formulas in cells C18:Q19 (VB) are not returning a result. The same formulas are in two other worksheets within the file and are working fine...just not in this worksheet.

    On worksheet 8GT2FG1314 in cell N23 - the value that it is returning is wrong. It should be 0.

    I know nothing about VB within Excel. I'm using that sheet that a user added the VB to last year.

    Any input would be appreciated. I'm at my wit's end.

    Mike

    ModuleGradeData8G2T20132014.xlsm
    Last edited by mwielgusjr; 01-24-2014 at 02:11 PM. Reason: Was told to

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: VB Color Function Error

    Hi Mike

    You need to be aware, I'm inept when it comes to seeing Colors as I'm color blind. However, on my platform, the Formulas in Sheet 8GT2J1314 appear to be calculating correctly.

    With regard to Sheet 8GT2FG1314, cell N23...the answer 1 is correct...take a look at Cell N10...it's Font Format is Green...hence it's getting counted.

    See this link on the usage of this Function
    http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

    Note especially this paragraph in the Link
    Be aware that the changing of a cells fill color will not cause the Custom Function to recalculate, even if you press F9 (Recalculates the whole Workbook). You will need to either, select the cell and re-enter the formula, or go to Edit>Replace and replace = with =, or use Ctrl+Alt+F9
    So, to recalculate, use Ctrl+Alt+F9
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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] Excel VBA: Dropdown box selection in first sheet to populate 2nd sheet from 3rd sheet data
    By EMLalan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-07-2012, 09:46 AM
  2. Replies: 0
    Last Post: 08-06-2012, 06:07 PM
  3. Creating Macro to copy excel sheet from workbook1 and past into excel sheet workbook2
    By t_gagliardi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2012, 01:19 PM
  4. Excel vba to copy sheet from current workbook to new Excel sheet ?
    By dearnemo385 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2012, 03:27 PM
  5. Copy from open excel sheet and paste into close excel sheet
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-13-2010, 06:07 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