I have an xls with one of its column having a list for data validation. I
want to add additional values to the list. When I go to data validation, it
shows me as list and it shows me the name as TBL_PEOPLE. I thot it might be a
label, but could not find it anywhere in the xls. I ...

I have two separate macro programs:
1. Run_Daily() - which is run each day, Monday to Friday.
2. Run_Weekly() - which is run only on Friday.
How can I combine them into a single program so that they still run

Ok, I am getting pretty frustrated with something that seems like it should
be so simple.  Can anyone help me??? Here is what I am trying to do in Excel.
I have a spreadsheet that is about 1100 rows long and about 14 colums wide.
I have all my information entered into the colums (it ...

When either importing ole or pasting from an Excel Woorkshhet into a Word
doc, only get a portion of the worksheet to show, even if I "copy" the whole
spreadsheet.

I've created a Excel template for a company for their member list. When I add
information in the cells for a URL of email address they are hyperlinked. When I
paste this info into a Dreamweaver table it loses the hyperlink. I then have to
manually create the hyperlinks in ...

How do I calculate child custody overnites?

I want to copy a value cell B2 into cell B3 IF a value in B1 is true.

I have upgraded from Excel 2003 to Excel 2007 and am experiencing a
tremendous decrease in speed. The following speed comparisons were done on
the same machinewith the same file containing about 50 columnsx 5000 rows of
data and 7 charts of the data.

I am trying to collect comments from sheet1!A1:A30 in sheet2, but not all
cells in A1:A30 contains a comment but are blank.
How do I automatic get sheet2 to collect all comments and only the comments
from sheet1?

I have a list of +2000 phonenumbers and they are in the format of
012345678 but must become 3212345678, so the first 0 needs to become 32
I searched, but was unable to find a solution. Any idea?
houghi

I click on a cell with my mouse none of my functions work.  I can't get out
of the cell or type or chose menu options.  Please help!!! I have reinstalled
program and mouse work fine with all other programs.

Is there any Short Key for "Centre Align", "Left Align", "Right align".....if
not please tell me any macro design for these purpose.

When you use the hyphen symbol, why do you get a short hyphen sometimes and
other times, it is wider?

I have just installed Office 2003 on a new PC when the user tries to colour
the cells in Excel nothing happens the cells stay at default.
We have re-installed, un-installed & installed again but nothing seems to be
working and its the only PC out of 50 that has this problem.  What ...

how do I locate an outdated link in a worksheet? I get a message when I save
that there is a bad link.  The worksheet saves OK, but I'd like to get rid of
the message and the link that is causing it.