|
|
Insert rows when data changes by
Russell Dawson[_2_]
In a column of periodically changing names in alphabetical order (col A) – I
need to insert a row after each change in initial letter. So when the names...
|
|
6 |
303 |
|
|
Excel slow to close by
Karl[_8_]
Since about 5/4/2010, Excel 2007 has started taking from 20 to 45 seconds to
quit after I select exit. I read about cleaning out temp files for slow
opening...
|
|
0 |
240 |
|
|
|
|
1 |
303 |
|
|
|
May 10th, 2010 04:58 PM
by martin
|
0 |
246 |
|
|
VBA inserting chr(10) or vbLf by
Jack Sons
Hi all,
In a for next loop I want to insert at a certain position (below it is
position 15) in a cell chr(10) (is that called a line feed?) to put the rest...
|
|
5 |
281 |
|
|
|
May 10th, 2010 04:37 PM
by Bob I
|
1 |
261 |
|
|
Office 2007 + formatting cells by
Neil Holden[_2_]
I have a cell with 6 numbers in for example 098737.
Excel deletes the zeros off from the cell, when i right click format cells
and go to custom i change...
|
|
1 |
179 |
|
|
Excel Edit and Replace by
Flipper
The edit and repalce function is not working liek I think it should. I have
one workbook with multiple worksheets in it. Each month I copy the prior...
|
|
0 |
254 |
|
|
|
|
1 |
221 |
|
|
Two formulas in one cell by
something68
Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate...
|
|
6 |
189 |
|
|
printing a specific worksheet everytime by
Trevor
I have made a quoting program in excel 07 that has 5 different worksheets
involved in it. I would like to send it as an e-mail attachment every time
as a...
|
|
1 |
228 |
|
|
Maximum Text in Cells for Printing by
Marie
I have read previous messages and responses regarding maximum text length in
cells, not visible on screen, or when printing.
I am using Excel 2007, and have...
|
|
1 |
208 |
|
|
Insert pdf file into Excel by
dhstein
I tried to insert a 20 page pdf file into Excel, but I only get the first
page. Can this be done? Thanks for any help.
|
May 10th, 2010 02:22 PM
by Betty
|
2 |
326 |
|
|
Check if variable is range by
Michiel via OfficeKB.com
This is probably very simple but I just don't see it.
How can I see if a (variant) variable is a range or something else (e.g. a
string)
Sub WhatIsIt()
Dim...
|
|
2 |
208 |
|
|
Financial Smart Tags Not Recognized by
djungst
I have setup a number of stack symbols and Excel 2007 recognizes most of
them. However, it does not recognize WU - Western Union or Mon - Monsanto.
Is...
|
|
0 |
208 |
|
|
Custom Data Validation by
Gotroots
Hi
Could someone be kind enough to tell me what is wrong with the following
formula
=COUNTIF($F11:$AN11,$AR11:$BF11,AN11)=1
Thaks
|
|
3 |
233 |
|
|
Excel does not calculate my formulas by
Martin
This is very strange...Excel does not calculate any formula. I can do a
simple =A1+A2, and it just return a zero value.
I made sure of the following:
- Cell...
( 1 2)
|
|
13 |
437 |
|
|
|
May 10th, 2010 10:23 AM
by Mike H
|
1 |
160 |
|
|
Conditional Formatting and Formulas by
BoRed79
Hi.
I want to set up some conditional formatting (in Excel 2003).
I want to turn certain cells either red (if any text appears) or green (if
the cell...
|
|
1 |
244 |
|
|
Invalid References in formula by
ck13
Hi,
I got this error message when i close my workbook: "A formula in this
worksheet contains one or more invalid references. Verify that your formulas...
|
May 10th, 2010 08:23 AM
by ck13
|
3 |
232 |