Hi' I have a spreadsheet (excel 2003) with data from a data base in one of the cells is text which is free typed in the data base and I want to find the...

Has anyone figured out a way to get this to work right yet? I have no merged cells and wrap text is on. Very frustrating. -- Thanks for the help

I cannot view the font color changes in excel, but the changes are on the printed page. How can I view the color change in the excel workbook?

Good Morning, I need help with the following: Gold pins go to employees with 30+ years, silver pins to employees with 25 - 29 years. I can't figure out how...

Can anyone tell me if an entire column can be used as criteria in a SUMPRODUCT formula? I tried: =-SUMPRODUCT(--('PS Sales'!$K:$K='Jan 09'!I$1),--('PS...

is there a way to do a data validation to a seperate spreadsheet that is not open. I have been able to do the validation to the spreadsheet but it must be...

I have a 2003 excel file which has many arrows (autoshapes)... once we upgraded to office 2007, these arrows appear bit moved (dislocated) when printing or...

Hi, I have a worksheet called "summary" and cell A119 picks up data from another sheet. Cell A119 contains a name from this other worksheet "Allotments". ...

Hi I have the following code: ActiveSheet.DrawingObjects.Select Selection.Delete However, if there are no objects to delete the code deletes the cell...

I am trying to format the text size inside the combo box. Is there anyway to do this? I am using MS Office 2000.... (I don't prefer to use Data Validation...

Before upgrading to Office 2007 I would normally click on File - Send - Mail recipients (or something like that). Now I don't have the option at all to email...

I have info that looks like this: AD0# Cost C D E F A B A 6567 6568 6567 $2,200.00 B $2,200.00 ...

I'm using VBA to try to get the data on the clipboard in Excel. I've found suggestion that are variations on the following: Dim MyData As DataObject ...

We have an Excel doc. on our server that we all use. Is there a way we can have multiple users in it at one time making changes? Currently if someone else...

I have an odd problem. I have a spreadsheet with 40 rows of data with columns from A to V. I then have two blank columns and then in columns Y to AB I have...

when drawing a line graph on excel how can you get the gradient on the line graph

Does SharePoint override the ability to share MS Excel workbooks? (I want to enable more than one person to update a workbook at the same time in MS Excel. ...

When working with values entered in cells if I highlighted a group of cells I could get a total value displayed in the lower corner of the screen. I don't...

Hi Wonder if you can help. I would like to put in some code to automatically (on open) do the following: Find the cell (in column A) with the word "Date"...

Hi, I put the below formula in the cell A1, i need to refresh it every one second so that it might look like a clock, can anybody help? =NOW()