|
|
|
June 16th, 2004 04:03 AM
by Biff
|
1 |
167 |
|
|
SUM IF multiple criteria by
kennis
I have figured out how to do SUMIF (A1:A8, "9", B1:B8) in order to calculate all the B values corresponding to anything greater than 9 in the A column. I am...
|
|
5 |
215 |
|
|
|
|
1 |
257 |
|
|
Launching Excel opens multiple workbooks by
Herb
This is particularly apparent when you double click an
icon to open an existing workbook.
Example:
I have a workbook named "Original Carrier List.xls"
When it...
|
June 16th, 2004 05:35 AM
by
|
2 |
373 |
|
|
|
June 16th, 2004 05:41 AM
by Biff
|
3 |
272 |
|
|
|
|
0 |
547 |
|
|
copy header/footer btwn sheets by
DebbieG
Gord,
What a great tip! This saved me a great amount of time and no errors.
Thanks,
Debbie
"Gord Dibben" gorddibbATshawDOTca wrote in...
|
June 16th, 2004 06:01 AM
by DebbieG
|
0 |
514 |
|
|
Linked workbooks by
AndyW
Hi,
I have a report template that I have just developed which
is populated from 5 other spreadsheets that are emailed
to me. I save these to a folder and the...
|
June 16th, 2004 07:18 AM
by
|
3 |
257 |
|
|
Excel Crashing by
Tony McGee
Hello all
Apologies all, I originally sent this to the VB newsgroup by mistake.
I am using Windows 2000 with Microsoft Office 2000 Professional. The...
|
June 16th, 2004 08:11 AM
by m
|
1 |
153 |
|
|
|
|
2 |
159 |
|
|
Autofilter number of records by
Thore
Working with Excel 2000.
Hi all,
normally when I apply an autofilter it shows in the bottom
left corner something like "2 out of 334 records found".
However,...
|
|
1 |
299 |
|
|
|
|
1 |
477 |
|
|
supressing the message box by
Anu
I have an excel macro which has some msgboxs with relevant messages
according to some business rules. I want to display these conditionaly
only when the...
|
June 16th, 2004 10:16 AM
by BrianB
|
1 |
150 |
|
|
|
June 16th, 2004 10:30 AM
by Jones
|
3 |
363 |
|
|
format change on paste by
glenn mckinlay
I am pasting data from an Access query into an excel
template and getting inexplicable cell format changes.
I preset the format on all cells in a column to...
|
June 16th, 2004 10:31 AM
by BrianB
|
1 |
458 |
|
|
check box for hiding columns by
Berend Botje
The script can be made shorter:
Private Sub CheckBox1_Click()
if checkbox1.value = true then
Range("A4:A10").EntireRow.Hidden =...
|
|
1 |
226 |
|
|
xls file in Excel97 will not open by
WimvV
I have a strange problem in our network.
A client can't open a specific xls-file. When he opens an other xls file
Excel97 works perfect.
When he logs-in on an...
|
June 16th, 2004 10:45 AM
by BrianB
|
1 |
351 |
|
|
Counting non blank cells by
jack evans
I want to count all the cells in a range that have text in them - I do not want to include any blank cells OR where a formula has returned an empty string....
|
|
5 |
477 |
|
|
export into excel from access error by
Panos
Hi,
I've got an access application which produces a report,
then the report outputs into excel. The excel application
opens automatically when you run the...
|
June 16th, 2004 10:57 AM
by BrianB
|
1 |
500 |
|
|
Copying formulae results by
stevie_ray
Hi,
I am currently creating a stock control spreadsheet for work. I need to
copy a column of formula results to a seperate column (the result only
not the...
|
June 16th, 2004 11:38 AM
by Paul B
|
2 |
214 |