I developed an Excel Workbook that has VBA to automate certain processes. It works without any issue in 2003. Now we have moved to 2007 and for an unknown...

I was wondering if code can be written to undo a previous vba action. Specifically I have a range of cell that I clear with some vba code. Was wondering if...

Is there a way to keep Excel on top of other applications?

I use to have this formula working in Office 2003 and now I am getting a value error - anyone see what is going...

How do I hide a comment in 2007? I have read the MS documentation:- Hide cell values - but cannot get what is contained there to work. Thanks in advance...

A document I have doesn't print borders. I see them on the screen and in print preview but not on the paper. The Draft Quality box is not checked. If I check...

Second attempt to post: I am loosing all my graphics on certian spreadsheets. when they open all the color, underlines - all the formats are gone. Im using...

I am fairly new to Excel and am using 2007. I have a block of words with all words being in separate cells which are A6 to I16. I need to perform a random...

I have a set of data in the form (9) (12) (8) (34) (45) I would like to search and append a '0' to single characters between brackets. Searching on (?) finds...

I have password protected several worksheets and have forgotten the passwords needed to un-protect the sheet. Any inexpensive (read free) methods to either...

Hello, I'm working on a sheet that will have a drop down menu with three options. Each option is expected to open a respective user form that has secondary...

hi community Dear All, I have started work in Excle 2007. my all file made in Excle 2003. Now I have save file in Excle 2007 through ^S, every time Excle...

hi community how can i convert total 790 days into years, months, days thanks community for the guidance :) -- oldLearner57

Hi, How can I re-write this formula so that when I copy it down 1 row the ref_text portion !d483 changes to !d484 ? =+INDIRECT("'"&'ACCOUNT...

I ma creating a dashboard in Excel. On my dashboard sheet, I will have about 5 embedded charts side by side. Next to the last embedded chart, I'd like to...

Hi In successive rows I need to find the X Smallest of a dataset given another dataset = a specific number. Return the first smallest score for competitors...

Hi, I am creating an efficiency report and I am stuck on a problem. I am getting a false statement when all the cells have no information in it when I...

If I attempt to open a .xls with Excel 2003 via Windows Explorer, Excel opens, but the sheet is never displayed, I receive a windows error message stating the...

i have office 2007 and some how my default excel name change from Book1 to Personal. can you help me change default name ...

Can someone please help. We have just upgraded to Office 2007 and now some of our spreadhseets have the following problem. Some cells are displaying as...