Has anybody run across the error where Excel will not allow certain operations because it says "no new fonts can be added to this workbook"? I'm working with...

Excel is limited to 65,536 rows. What is the work around to make this limit higher?

Is there a way to compare 2 worksheets that are not in a shared file?

Hi all, I am using the VLOOKUP formula to cross-reference two sheets. I know that a lot of my data from the first sheet wont be in the second sheet, so it...

Hi Group, Need your help. I have these coloumns: Employee Code Name Status Position DOJ DOL Tenure Reason of Leaving Ed Level GENDER LOCATION

I have an Excel file shared by various people and it will not open completely because it says the file is reserved by one of our members. That person doe not...

Hi for the range A1:A10 try =SUMPRODUCT(MAX((A1:A8+A2:A9+A3:A10)))/3 Note: does not take blank or text cells into account -----Original Message----- Hi, I...

I will do my best to explain my problem….. When we receive orders we typically allocate a 5 working day lead-time, each job has a number of operations (steps...

Using excel 2002 (OS=XP PRO) when creating Macros before have always relied on the dialog box that normally comes up when you close excel -Asks whether you...

I have cells containing dates in different formats: 01/01/04 2-3 June 2004 August 2003 How can I extract the last four (or two) characters to just get...

I have a user form in my database which works fine. I need to create another form with the exact same layout, however, when I try to copy the form and its...

I have a long list of data and want to name each cell individually by using the reference of cell on the left and at the top. e.g. Column A B...

Hi all, I have a hyperlink in an Outlook 2000 email that links to a Microsoft Excel 2000 file that contains vba code. The Excel program generates the error...

Hi, I'm trying to reproduce a calculation that is on a spreadsheet I have been emailed by a former employee. The calculation starts {=Sum(..... and ends...

Hi I have been looking for a way to transfer a row of data to a column i.e. a1 to a1 b1 to a2 c1 to a3 etc. is there a process or formulae available

Hi.. i hv 1 question to ask. Assume that i have more than 200 worksheet into 1 excel file, so imaging that i need to go back to the first worksheet from 350...

Hi, I got a document where hundreds of cells are filled with lots of text. Whoever worked on it used the Alt + Enter function to create a new line (instead...

I've a number of spreadsheets that retrieve external data from a SQL Server database. (These were written using the wizard invoked by Data Get External Data...

Hi, I wanted to record a macro from my worksheet, But instead of selecting some rows which is having some data of the present day. i would like to use TODAY()...

I am trying to link from an excel cell to a bookmark in a word document. I get an error that excel cannot parse the word file. Any ideas. As much as i like...