Hi there,
I am trying to sum the first 2 characters of a cell which works fine when
they are all numeric but when one isn't it falls over
The data:

How to I adapt this formula to insert 8 blanks rows?  Right now it inserts
only one, and I can't read this stuff!  Thank you.  Connie
Sub InsertRow_At_Change()
Dim i As Long

Can I use two formulas in a cell? If so, how? I would like to use
=MAX(SUM($F$4:F5)-50,0) and =IF(A5<=TODAY(),J5+329.230769230769,"")
Thanks

I keep hitting the email icon when I'm trying to save a workbook in Excel,
and then my workbook drops into my Outlook email program and I can't cancel
or get out of the operation and back to my regural Excel worksheet.
The "undo" button is grayed out and unavailable.  I know there ...

I have a column of names and in the column there are 20 rows saying "apples"
and 10 rows saying "oranges" and 5 rows of "bannanas". I would like to
produce a report that pulls only the name i.e. "apples", which would then
allow me to produce a consolidated list of names.  This ...

i am comparing pairs of cells in a column of data using an if statement.  if
the statement is false i would like to add a row between them.  i have
created a macro that just adds a row but i dont know how to nest it in an if
statement nor do i know exactly how to make sure that ...

I want to get list of all possible permutations when conditions defined. For
example, I have a word "AMERICA". And I need the list of permutations when
two
letter is taken at a time.

when I make short cuts to my often used excel books I cannot access them by
double click excel starts but the screen is greyed out any ideas

I have to use SUM IF Funkcion, and I am not sure how. What to put in Range,
Criteria and Sum_range?

I would like today’s date to show up also, I am using this formula
=IF(A6<TODAY(),J6+329.23,"")
It is working, but today does not show up until tomorrow.
Thanks

Is there a shortcut key so that I can get a number to appear as (5,444.00) ?
Driving me crazy :)

Help, how do you open dialog box to filter a column so date can be selected
or is there a better way to do this?

I'm looking for a formula that would reflect the following:
saterday - thursday.
Should only reflect days from above but skip
friday when drag/drop through the column.

I want to insert a hard hypen to keep a hyphenated word together, not have
the word separate to a new line.  Also, if there are keystrokes that will do
this, as opposed to using the mouse, I'd like to know what those strokes are.
Thank you.

If I formulate a column to time, and if the time in the first cell is 6:00 AM
and I drag it down, it advances by one hour.  How do I get it to advance by a
half hour?
Connie