Hi, Why isn't there an icon for pasting formulae only, there is for values and formats? I've written a macro to do it but this is not ideal because you need...

Hi, I am running Office 97 on a Win Me platform. When I attempt to do anything related to adjusting margins in Excel the computer hangs. The only...

I mean this is something basic but I have just upgraded to Office 2003 and I can't find how to backup my excel document that I havw open

In Office 2002’s Excel and Word (under Windows XP Professional SP3) when attempting to open a file (File Open Look in: a different directory) or...

I am new to VBA programming for Excel, and I need some help on how to accomplish the following: I have an existing spreadsheet with 5 charts. I would like to...

this is a question on fundamentals of excel for e.g. cell A2 is blank. I confirm whether A2 is blank by going to another cell and typing =isblank(A2) which...

:Hi, I am writing this from an example from Debrah's web site: I am not sure how to test it to see if it works. When I try it says sub error? Private Sub...

I've been trying to combine a vlookup function with a sumif function for weeks now, however, without success. This is my problem. Instead of looking up a...

Where and How to find the list of commands for create macros in Excel?

Is there an automatic display/print the filename on a workbook in Excel 2003 in the footer?

For some reason, when I crashed out of Excel one time, I lost the capability of toggling between workbooks in one Excel session. I can still do this...

I would like to have a bill of sale

I've imported some MYOB general ledger reports into Excel, but have found that Excel 2003 reads dates in the first 12 days of the month as MM/DD/YYYY (USA...

I have a column of text cells (each with different number of words), And need to count those cells which meets the following conditions: They have the text...

I have the following index formula '=INDEX(PlanPax,A21,$B$4)' where cell B4 is the month number e.g. 3 for March. How could I amend the formula (and cell B4)...

I have a spreadsheet where one column is cells that each contain 30 to 50 words of text. Even after applying FORMAT, ROW, AUTOFIT when I print I lose the top...

i wish to set up a countdown timer showing date + hours, minutes and seconds i have used the formula =now() for todays correct date and time and a fixed date...

How to print worksheets of the same name in different workbooks without opening each one? -- Message posted via http://www.officekb.com

how do I set up a command button that works with a combo box

One user has problems viewing and printing Excel worksheets. Each cell becomes a page in the workbook. When I do a page break preview it shows each cell as a...