Hi. I'm having some difficulty with a problem which seems like it should be
simple. In column B I have a list of money amounts, "charges", which include
the occasional negative number, "payments". In column C I need to total all
the positive numbers and in column D all the ...

I am creating a spreadsheet in Excel 2007 that uses Goal Seek in a VBA macro.
It does what I need it to do, except that the new value placed into the "By
Changing" cell doesn't appear unless I navigate to another sheet or hit F2 to
edit it.

can any one give me the formula to work out what time it took to do X miles
at an average speed of Y?
Thanks
Jon

On a userform being used as a LogOn, I have two textboxes...txt1 & txt2. and
Commandbutton1 = Login Commandbutton2 = Quit.
The end user will use txt1 as a UserName entrance & txt2 as a PassWord
entrance. The enduser will use Commandbutton1 to Login once username and

Question number one: (and this is a simple one I hope) were I wanting to do a
COUNTA to concentrate on specific cells in increments of 10 and missing out
those between, I.e A1, A11, A21 and so on...how would I do this, without
overloading the formula as this needs to be repeated ...

I wanted to start a forced new line after typing down the texts which
wraps down automatically in a given excel cell. Pressing [Enter] just
like any other Microsoft Office documents would take me to the next
cell as selected!

I'd like to teach myself vlookup are there any online courses that will teach
me or and courses i should take before attempting to learn this function?
Please Help. Thanks in advance for reading my posting

All of a sudden, the HOME key in Excel has stopped moving the cell pointer
to the beginning of the row. Instead, it's sending the cell pointer to the
END of the row (actually, the cell immediately to the right of the last
cell in the row that contains data).

On a project timekeeping spreadsheet, I have an accumulating 'hours
worked' field formatted as [hh]:mm.  I'd like to be able to multiply
this by an hourly pay rate to show money earned so far, and then
display this with currancy format.

ok here goes...
what i was wondering is hard to explain so ill explain it in an smal
example...
i have 3 sheets in my workbook, 'week1', 'week2' and 'total'

How do I password protect a shared excel book so that people have read only
access but so thta I can have write access?

I am using Microsoft Excel 2007. I have an account number in C:2.
Associated with this account number is a set (in a column) of 3 digit
numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers
in Column W, there are blank spaces under C:2. When the next account

How do I format an entire column to automatically convert the number:
1236785555 to appear (123) 678-5555?

I WANT RECURRING ENTRIES INTO EXCEL TO POP UP AS I TYPE THE FIRST LETTERS.
SOMETIMES IT IS HAPPENING BUT MOST OF THE TIME IT IS NOT.

I am very new to Excel VBA (within the past few weeks).  I am trying
to write something that is way above my head right now.  I would
appreciate if someone could get me started in the right direction.  I
have a list of dates and data which accumulate in a workbook.  I would