|
|
"macro Worksheet" by
sal
HiI have created a few macros using VBA in excel.
I now want to use a macro worksheet instead, since it seems easier to
find your macros. This is totaly new to...
|
|
1 |
264 |
|
|
|
|
2 |
426 |
|
|
"Microsoft" Patch Virus Messages by
Alan
Does anyone know if the flurry of these things appearing in the newsgroups
recently is due to people maliciously sending them, or if the virus is
sending...
|
|
5 |
436 |
|
|
"Not enough memory" by
Bill H.
When working with a small excel file (136 KB) I get the "Not enough memory"
error.I've cleared the save external link values but same message. Any simple
fixes?
|
|
2 |
120 |
|
|
"ON ERROR GOTO" by
Krappo
Hello ppls,
I need an Error Handler which looks like this:
Sub Macro1()
On Error Goto AAA
Workbooks.Open Filename:="C:\dir\dir\book2.xls"
Exit Sub
( 1 2)
|
September 21st, 2003 03:31 AM
by Krappo
|
13 |
275 |
|
|
"OR" function by
Connie
Working with Excel 2000.
My workbook has four worksheets. Worksheet 4 is a summary
of some of the cells in the first three. One employee may
only be required...
|
November 6th, 2003 09:28 PM
by
|
4 |
163 |
|
|
"OR" in a array by
wildman
=SUM(IF((FIXEDm!$F$2:$F$5000="WG1")*OR((LEFT(FIXEDm!$I$2:$I$5000,4)="2q13"),(LEFT(FIXEDm!$I$2:$I$5000,4)="2q15"),(LEFT(FIXEDm!$I$2:$I$5000,4)="2q17")),1,0))
I...
|
September 30th, 2003 04:10 PM
by Dave
|
3 |
144 |
|
|
|
|
9 |
127 |
|
|
|
|
2 |
284 |
|
|
"Pleading paper" in Excel? by
geebee
I need to be able to print Excel data so that it looks like it was printed on
"pleading paper" (this term will be well-known to legal-types. It mostly
involves...
( 1 2)
|
|
15 |
435 |
|
|
|
|
1 |
134 |
|
|
|
|
7 |
374 |
|
|
"proper" function excel wksht by
CajnBred
Why would the "proper" funtion for capitalizing work on some columns of my
worksheet and not on others. Some display the proper Capitalized text,...
|
|
2 |
112 |
|
|
"Randomising" "number" by
Leslie
I have a worksheet, cells, b1, b2 and b3 of which each contains a 10-digit
hexadecimal number.
In another cell, I have the following formula:...
|
February 10th, 2005 08:02 AM
by Leslie
|
3 |
105 |
|
|
"Saturday as a work day? by
keith m
I am using the formula "=Workday" but I want this formula to include
Saturdays. I have a Start Date and a duration and want to calculate the end
date with...
|
|
6 |
118 |
|
|
|
April 21st, 2004 07:06 AM
by tal
|
0 |
308 |
|
|
"Select" type statement by
Richard Davies
Hello all
I have a grid of data, with prices for posting parcels in the UK.
There are 3 different ways which parcels get sent, 1st Class, 2nd Class...
|
|
1 |
212 |
|
|
"Sort" help by
lehu
Hi, maybe someone can help me with a simple "sort" question. I'm using
excel 2000, how do I sort in the order that the data was...
|
|
1 |
166 |
|
|
"Suggest a match" from a list or drop down. by
pjpuddles
Is it possible to pull information from a database into another worksheet
without having the exact spelling of that information?
I have a database with names...
|
|
0 |
94 |
|
|
"Sumif"or "if" ...followup question by
Peter
Thanx, Paul, that worked! But I have another question. If
I get a "NO" and enter that in the RSVP column, can I get
the "balance due" to blank...
|
September 16th, 2003 11:24 PM
by James S
|
1 |
333 |