|
|
Inverting an advanced filter by
Kevin Lucas
I'm using the advanced filter and would like to be able to see the set of
rows that are hidden after I've viewed the set of rows that the filter
shows. Some of...
|
|
3 |
343 |
|
|
Automatic Minimization by
brian
When i leave Excel on, and my monitor goes to a screen
saver mode, Excel shrinks to a window that shows only the
top tool bar. This causes me to have to click...
|
|
1 |
155 |
|
|
OLAP Cubes in excel by
Jane
I am having problems using OLAP cubes. I have successfully
created a cube and pivot tables using this cube. I refresh
the first pivot table and it works ok....
|
June 16th, 2004 11:49 AM
by Jane
|
0 |
236 |
|
|
|
|
1 |
174 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
June 16th, 2004 10:30 AM
by Jones
|
3 |
363 |
|
|
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 |
|
|
|
|
1 |
477 |
|
|
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 |
|
|
|
|
2 |
159 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
0 |
547 |
|
|
|
June 16th, 2004 05:41 AM
by Biff
|
3 |
272 |