Suddenly getting "wait while configure Office XP standard" when opening Excel. Then it wants the disk. Excel was purchased online/download, so no disk....

I created an hours sheet and about a week after creating it I needed to add another day. When I type in 7/31/04 and hit enter what appears is ######. What is...

Hi I'm using MS Office 97 and opening Excel files just by double-clicking has always worked fine. A few weeks back the excel file type became associated with...

I am trying to get a multipage1.pages(1).textbox1 to show all the text in all the cells of an activeworkbook.worksheets("sheet2") this is one of many...

Hi, It doesnt trouble me anymore because I have adjusted my work settings but just wanted to share what I faced in the past. If our calculation is set to...

Hi, A question from a newbie. I am working with a template from Microsoft's website. I started to customize it yesterday and everything was going well. I get...

I am using Excel 2000 and I have a list of music artists running down the A column. Some of their names are not properly identified unless "The" appears first...

Is there a way to copy all the file names in a directory into excel?

Hi, I have a database that consist of the records with the following fields: 1. Name of the country 2. Year 3. Parameter 1 name 4. Value

If you please..... I would like to do this: If A1="XXXX" copy A2 to B1 If A22="XXXX" copy A23 to B2 If A29="XXXX" copy A30 to B3

Hi all, I would like to know more about password protection of Excel worksheets/books, formulas, and VBA codes. Is there secure ways to protect your formulas...

Hello, I have a spreadsheet with over 100 graphs which need to have the text formatting changed. I could select each category axis, value axis, legend, and...

Am designing a golf score card, two on the same sheet. Am attempting to re-size columns in card one and it changes card two. They are above each other. Any...

BadBlue's Excel sharing features for web browsers changed with version 2.5, they look dramatically better - see http://badblue.com/helpxls.htm for a...

Hello, I have an Excel spreadsheet built on Excel 2000. I have set sheet protection with password, and I have some unprotected cells with drop down menu...

Is there a keyboard shortcut for returning to the most recent edit (equivalent of Shift+F5 in Word)? . Thanks

I received a data file of names and addresses. All of the data is in column 1,i.e., name in line 1, address in line 2, cioty-state-zip in line 3 - then a blank...

I have a list as follows: Col A -- Vendors Name Col B -- Part Numbers Col C -- Condition of Item Col D -- Price My purpose to find out the cheapest price: let...

HI, How can I find a specific string in a text within a VBA code. For example - to search "Japan" in "the capital of Japan is Tokyo" and receive "TRUE" if...

I use concatenation to construct formula that suit particular conditions in one cell. However, when I try to have the results automatically converted to a...