I'm trying to create a code to appear a msgbox type vbyesno, but I
don't now how create it. And I need help with the code, if the user
click in yes or in no.
for example, if the user click in yes, the workbook save and close; if

One column for the dollars and the other for the cents?  If so, use the Text
to Columns, Use Delimited as the split option (Step 1) and select Other, type
in the decimal point in the blank to the right of the Other option in step 2.
This is good, but how do i keep it in the ...

I am using this formula:
=(A1&", "&B1&", "&C1&", "&D1&", "&E1&", "&F1)
Problem is, sometimes a few of the cells are blank.  I end up getting
2 commas , , together.

sorry if this is a repeated question in this ng. I just could not find one
related my querry.
I have sitmap list in excel. I want to separate the links with the word
images in it.

What am I missing here? In Excel 2003 I was able to create a pivot
from a query in a Access 2003 database.
Now when I go to create the pivot in Excel 2007 I only get the Access
table to show up, not the queries.

Hi! -
I was hoping someone could help me please. Here's what I have. A
worksheet that has several dates in a row. D1:T1,  Of that range, I
have conditional formatting set to highlight a date(s) either = to or

I need to transfer data from one worksheet to several others, any ideas how I
can do this? Gratefully accepted

I am working with a spreadhseet and the data looks normal, however
when you click on the cell the data value contains a leading
apostrophe.
for example the data looks like this:

I have an app that is database driven and there are many times where I
need to make queries out to the database to populate Combo Boxes and
List boxes.
In my current code, I have to explicitly set the code to populate the

Hello NG
My Excel 2007 has stopped auto updating formula cells when one of the input
cells are changed. It will only update the value if i mark the cell and
press enter, or save the file.

I have a problem with an improved HLOOKUP formula.
My problem is fully describe into the attached Excel file
http://cjoint.com/?hunXEMJti3
If anyone could help ... many thanks in advance!

I need some help.  I have a team of about 40 people entering data into
individual spreadsheets.  Currently we go to each directory and copy the data
and paste it into a single spreadsheet to send to our corporate office.  What
I would like to do is create a spreadsheet that we ...

Is there a way that I can edit a range name to include more rows than
originally selected?
If not, how do I delete a range name so that I can re-create it with the
correct row and column addresses?

Autonumbering
I am using Office 2003 and have the following problem
    Col B
1  Mar-07

I have a table that looks like this
-----A------------B-----------C-------
Part Number------Qty-------Price Each
1----Part 1---------2-------------23.01