I had a directive to create an array, find the largest value, then find the index number of the largest value in the array. I have most of it written, but I'm stuck calcualaing and showing the index. Here is the code so far:
#include <iostream>
#include <cmath>
#include <iomanip>
using...
I am working on a workbook and I want to use an checkbox control to be checked off on each sheet when the worksheet is completed. However, there is one merged cell (d15 -k15) on each sheet that needs to be filled in with text before the sheet can be considered complete. I tried using this code...
I am working on a workbook and I want to use an checkbox control to be checked off on each sheet if the form is completed. However, there is one cell on each sheet that needs to be filled in with text before the sheet can be considered complete. I tried using this code attached to an ActiveX...
Here I am again:
This time, I am attempting to create a smiley face (done) with a button that will change the smile from a frown (my problem). I believe I'm almost there, but I'm missing something that is probably relatively simple...
My code:
import java.applet.*;
import java.awt.*;
import...
I submitted a question pertaining to conditional formatting that was answered in this thread:
thread68-819125. When I do this manually, it works like charm. However, when I try to incorporate this method into an existing macro, it does nothing. Here is the code it is a part of (inserted code in...
I created several private views from a Notes db so that I can update a daily report by just glancing at a view and not opening every record. Every couple of months, Notes Admin does a db refresh and my private views disappear with the old version of the db. Isn't there a way to keep my private...
I produce a daily timeline report that reads from dates and times from another worksheet in the report. The formula that I use to create my ‘timebar’
=IF(AND(E$1>=($C2-TIME(0,0,1)),E$1<=ROUND($D2*24/0.25,0)*(0.25/24)),"P","")
Row 1 holds the value for each hour of the days I am currently...
I created two macros in Excel 2000 that hides and unhides rows that do not have shading in them and they are assigned to a toggle button. However, when the same macro is executed in Excel 97, users get a Runtime 1004 error that says "Unable to set the Hidden property of the Range class." Here is...
I started this out as one class, but I need to separate it out into different classes with constructors, getters and setters. I've gotten this far and now I'm lost. Plus now I get an error:
java.lang.Error: Unresolved compilation problem:
Syntax error on token "principal", ".", "[" expected...
I produce a daily timeline report that reads from dates and times from another worksheet in the report. The formula that I use to create my ‘timebar’
=IF(AND(E$1>=($C2-TIME(0,0,1)),E$1<=ROUND($D2*24/0.25,0)*(0.25/24)),"P","")
Row 1 holds the value for each hour of the days I am currently...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.