Any way to get rid of Sheet1 and ThisWorkbook modules in Add-In project?
Sat, 20 Mar 2010 20:32:34 -0700
I have a couple of add-in files. In the Project Explorer, they wach
show two modules in addition to the modules I explicitly created:
Sheet1 (Sheet1)
This Workbook
Is there any way to get rid of these modules? I tried right-clicking
on them, but the Delete option was greyed out. ...
|
Ctrl-H crashing Excel 2002 fixed by Office XP SP3.
Sat, 20 Mar 2010 15:40:55 -0700 (PDT)
In thread "Ctrl-H crashes Excel 2002", a couple of dozen threads
before this one, I reported that, in Excel 2002 without Service Packs
applied:
After you do a search by Values (as opposed to Formulas), henceforth
Ctrl-H crashes Excel.
(You could prevent that by reassigning Ctrl-H to a macro.)
Thanks to M ...
|
Excel viewer does not display formula values
Sat, 20 Mar 2010 09:42:12 -0500
To all Excel gurus,
I have a formula in my 2007 SS =SUM(A1:A10). Viewing this SS in Excel
yields the result (100.00) but when I view the SS in Excel viewer
XLVIEW.EXE, the formula cell is 0.0. Why is that or did I download the
correct viewer. Actually all the formula cells in the SS is '0' when
viewed by ...
|
Insert random number only if cell empty
Sat, 20 Mar 2010 09:38:30 -0500
Hello. I'd like my spreadsheet to place a 7 digit random number into a
cell only the cell is empty, otherwise leave the contents as is. I
simply don't want the number to change if one is already present.
I currently keep the number static by pressing F9 when I enter the
RAND formula, but that forces me to ma ...
|
Countifs formula not calculating my specific data
Sat, 20 Mar 2010 07:25:01 -0700
I am working with a Countifs formula, and it is not returning the correct
information when I am using the specific data I want, but if I simplify it,
it will return what I want. i.e.
=countifs(A3:A500,"1/?",B3:B500,"DAYTONA",C3:C500,"SMITH, JOHN")
^THIS IS NOT WORKING, BUT......
=COUNTIFS(A3:A500,"X",B ...
|
Rationalising a formula
Sat, 20 Mar 2010 09:30:38 +0000
Hi,
Could anyone suggest a way to rationalise this formula:
=SUMPRODUCT(('Tests 1'!$Z$3:$Z$970="Derbyshire")*('Tests
1'!$AG$3:$AG$970="TERMINATED")*('Tests 1'!$AE$3:$AE$970>=$C$3)*('Tests
1'!$AE$3:$AE$970<=$H$3))+SUMPRODUCT(('Tests
1'!$Z$3:$Z$970="Derbyshire")*('Tests
1'!$AO$3:$AO$970="TERMINATED")*('T ...
|
Splitting an add-in module
Sat, 20 Mar 2010 00:00:22 -0700
I have had an add-in module for several years. I want to split it into
two modules. The current add-in module (Add-In 1.xlam) is in
C:\Documents and Settings\Administrator\Application
Data\Microsoft\AddIns
I made a copy of the current add-in and gave it a different name
((Add-In 2.xlam). I opened Excel and ...
|
|
|
fraction difficulty
Fri, 19 Mar 2010 23:16:27 -0400
I have office 2000:
I want cells to show up as fractions, but I want them all in 1/8th
increments.
I don't however want 2/8, 4/8 or 6/8, but 1/4. 1/2 and 3/4.
I can format each cell individually, but this creates problems if the
data changes.
TIA
Phil ...
|
Excel Problem
Fri, 19 Mar 2010 07:19:53 -0700 (PDT)
Last night Excel started messing up on my computer. Dell Computer
about 6 years old. Windows XP Pro, MS Office 2002. Open a
spreadsheet, Excel opens to a blank spreadsheet and then says it has
encountered an error and shuts down. Error appears to be something
about a kernel 32.dll (not sure). Tried detect ...
|
Formula wanted
Fri, 19 Mar 2010 05:55:01 -0700
Hi.
I have two columns in Excel. In first column A1:A100 i have some integers
and empty cells and in second B1:B100 I have some stings and also some empty
cells. I would like to apply a formula in C1:C100 somehow in a way:
a) to include all stings Bi that the corresponding Ai are numbers
b) with non blank ...
|
