|
|
VBA: Where to find Excel Object model? by
N. Foldager
In a textbook I read that this object model is found by a search in the
Visual Basic
Editor using the term "excel object model". The search should...
( 1 2)
|
|
13 |
805 |
|
|
"Recently Used File List" by
phil6666
Using Excel 2002...
Is there any way to remove files from this list other than waiting for
them to be replaced over time?
( 1 2)
|
|
13 |
232 |
|
|
VBA Error in Excel 2003 by
Mike Flory
I have recently upgrade from Office XP to Office 2003. I'm running XP Pro
w/SP2 and all of the updates for Windows and Office. Here is the problem...
( 1 2)
|
|
13 |
236 |
|
|
Formula to Text to Formula by
Bonnie
Hi there! Using E02 on XP. Have zillions of formulas to
create and if I can get my template going, it will be much
easier. Only problem is this: I used Replace...
( 1 2)
|
March 30th, 2005 10:57 PM
by RagDyer
|
13 |
191 |
|
|
Execute Macro automatically after hyperlink by
Bill Elerding
I have set up hyperlinks in a table of contents that jumps to specific
categories (individual cells) on the next worksheet. I'd like to have a
macro execute...
( 1 2)
|
|
13 |
142 |
|
|
MODE by
Micayla Bergen
help says i cant use the mode function on text in a table, is there an
equivalent function for text?
( 1 2)
|
|
13 |
162 |
|
|
sumproduct if by
sumproduct if
i need a "sumproductif" function:, a combination of sumif and sumproduct
e.g. i need to sumproduct values in columns A and B if a condition in column
C...
( 1 2)
|
|
13 |
250 |
|
|
formula not working by
Micayla Bergen
= SUM('A & E John Super'!$P$4:$P$39)/SUM('A & E John Super'!$L$4:$Q$39)
where =IF(ISERROR((VLOOKUP(A12,'share detail'!$D$2:$D$52,1,
FALSE))),"",I12&J12) is on...
( 1 2)
|
|
13 |
194 |
|
|
Link to Workbook by
Andibevan
Hi All,
Quick question - If I have a statistical calculations spreadsheet that is
linked to a seperate data sheet - does the data sheet have to be open...
( 1 2)
|
|
13 |
224 |
|
|
|
|
13 |
202 |
|
|
|
|
13 |
452 |
|
|
black dots at begnning of some cells by
jenn
Hi,
When my supervisor creates spread sheets and sends them to me some of the
cells have a little black dot at the beginning of the cell. It is right at
the...
( 1 2)
|
|
13 |
161 |
|
|
vlookup help by
jtinne
I need a couple formulas to search a range of sheets on my workbook.
The first one needs to be able to seach through a range of sheets (exp.
sheet 20 to sheet...
( 1 2)
|
February 7th, 2005 05:49 PM
by jtinne
|
13 |
157 |
|
|
Checking ALL values in a range by
nospaminlich
I'm trying to create a formula which checks that a range of cells e.g. A2:F2
contain all the values 1,2,3,4,5,6 irrespective of which cell each number...
( 1 2)
|
|
13 |
471 |
|
|
Add Sheets and rename by
GregR
I have a workbook with one sheet named Sept. I want to add 11 more sheets,
name them Oct - Aug and copy the contents of the original sheet to the new
sheets....
( 1 2)
|
|
13 |
242 |
|
|
Text fomula by
gregork
In cell B1 I could have any one of the following text examples: big apple,
small apple, orange, apple, pear etc. In A1 I want a formula that will
return...
( 1 2)
|
|
13 |
234 |
|
|
Help with copy macro by
Kel
I have many tabs that I want to copy information into a new sheet
within the same workbook. I need to Copy A5 into Column A, A10 into
Column B, C3 into Column...
( 1 2)
|
|
13 |
146 |
|
|
Loading excel by
Mike R
I just installed xl2000 on my laptop. I have been using it on my pc so I
copied and pasted my personalxl file into the xlstart folder, thinking I
would have...
( 1 2)
|
March 1st, 2005 07:04 PM
by Mike R
|
13 |
157 |
|
|
concatenate like sumif by
Simon Shaw
Is there a function like SUMIF for text values that concatenates rather than
sums?
I have a set of data as follows:
Truck No. Product Comments
-----------...
( 1 2)
|
|
13 |
196 |
|
|
Wrong date on my posts. by
Gord Dibben
Apologies to all for the wrong date on my posts for the past day.
Was playing with system date and neglected to change back.
Gord
( 1 2)
|
|
13 |
187 |