|
|
"Automation error Catastrofic failure" by
Francois Benadie
I got this message as soon as I open an excel file that has some macro's to
do calculations and change some of the user interface.
I think it is connected to...
|
|
2 |
136 |
|
|
"AutoPrint" type macro requires tweaking by
1drunkbrit
Hi everyone
For quite some time now, I've been using 5 near identical macros to
help me print off some bi-monthly reports that use an "overview" sheet
that...
|
|
0 |
198 |
|
|
"Avanced?" Filter by
comotoman
Is there a macro or a way to base auto filter on a cell number.
a6:a100 is the filter area. (numbers 1-12)
d4 could be a number from 1-12
i would like...
|
|
2 |
152 |
|
|
"average" IF by
mpanty
Hi.
I have a table with rating values for each game my team plays, and the
games played belong to different categories (league, friendly, cup
etc.).
My...
|
August 26th, 2005 07:20 PM
by mpanty
|
5 |
164 |
|
|
"Average" with error DIV/0 by
agenda9533
Taking average from data below I get DIV/0 Error
J42=AVERAGE(J40:J41)
J40 00:16:40
J41 00:09:53
J42 #DIV/0!
Thank you
|
March 2nd, 2005 05:47 PM
by Dave O
|
1 |
134 |
|
|
"AverageIF" alternative by
Flutie99
Since there isn't an averageif, what is the best way to average a particular
set of numbers? Thanks.
|
|
2 |
289 |
|
|
"Between" in an IF clause by
gavin
I have the following formula which works OK:
=IF(ISBLANK(AJ2),"",IF(H240,'Jobs (2)'!F2*0.682,IF(H2130,'Jobs
(2)'!F2*0.781,"0")))
But I need to add another...
|
|
5 |
134 |
|
|
"Bloated" Excel workbook by
Shirley
We have a 3 page Excel 2002 workbook. Four of us each copy it from a folder.
paste to the desktop, fill it in with the day's accounting figures and then
email...
|
February 24th, 2005 10:21 AM
by Shirley
|
5 |
156 |
|
|
"calculate" at bottom of worksheet by
bruno
"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when...
( 1 2)
|
|
11 |
712 |
|
|
"Calculation" in status bar by
rich
I have one woorkbook that the "Calculation" lite in the
status bar stays on. I do not have "manual calculation"
turned on. How can I fix?
|
|
1 |
130 |
|
|
|
|
1 |
398 |
|
|
|
|
3 |
119 |
|
|
"cannot empyt clipboard" error by
AP
I am getting the cannot empty clipboard error after every cut/paste or drag/
drop. I'm running Windows XP & Excel 2003. Is there anything to fix this?
|
February 9th, 2005 05:37 PM
by AP
|
0 |
121 |
|
|
|
February 2nd, 2005 11:05 PM
by Dee
|
0 |
130 |
|
|
"Check Marking" a cell by
FVC
Can I format (via Macro???) a cell so that if the user left clicks on the
cell a check mark appears without using the Control Toolbox. The cells with
such...
|
April 8th, 2005 09:21 PM
by David
|
2 |
69 |
|
|
|
|
1 |
129 |
|
|
"Clocking" events in Excel by
Pete
I’m writing a psychological test which will flash simple 4-choice multiple
choice questions and score how quickly you hit the 1, 2, 3 or 4 key. I need
to...
|
October 22nd, 2004 03:43 AM
by Pete
|
4 |
138 |
|
|
|
February 15th, 2005 07:45 PM
by ajr
|
0 |
68 |
|
|
|
|
1 |
89 |
|
|
"combo box" by
adam.ronalds
how do i get the control combo box to stay in place on the worksheet? I
print or print preview and it resets the placement of all my control combo
boxes.
|
|
2 |
127 |