error message

Hi! I'm having a CountIf problem (grrrr that darn function!) that I'm hoping someone could help me with. The following code is the 3rd or 4th version I've tried to get working, and they all return errors. Right now I'm getting a "Unable to get the CountIfs property of the WorksheetFunction...

I need some assistance. I have a formula already but I need to add for more columns to it and I keep getting the error message - "you've entered too many arguments for this funtion" Below is the original formula and what i need to add. =IF(ISNUMBER(MATCH("x",K5:N5,0)),CONCATENATE(FY_11_Word,"...

Hi there. I have 2600 rows of manager data that require filtering over multiple worksheets. I found the code below from the following website: http://www.ozgrid.com/forum/showthread.php?t=76618&page=1 I attached it to a command button, so when select one manager, if filters that...

I'm getting the error: "Unable to get the Match Property of the WorksheetFunction class" and I'm not sure why. I've seen several other posts with this issue, however have not been able to find a solution. I attempted to use an IsError Function to see if the Match function just wasn't finding the...

I created a (Menu) sheet, full of text and image hyperlinks. Most are Bookmarks to other worksheets. Although they all work perfect for me, they do not work for the person I need to share the workbook with. When they click on a Bookmark/Hyperlink, they get the following error message: "This...

Hello All, I am using Excel 2010 (Not Beta anymore) and I am getting an error message whenever I highlight multiple tabs (more than 6) and try to do something like Delete all contents in tabs? Any ideas why this is happening? The file isn't even that large? And I do multiple SAVE's while I...

I get an error when trying to save, "Minor loss of fidelity" in Excel 2007 spreadsheet. How do I eliminate this warning everytime I save the file? I recently upgraded from 2003 to 2007 and now get this error. Some files have 18 "number of occurrences" under this warning. "Some cells or styles...

how do u add error message, so that if you do not put the correct type of value in a input box and a error message should come for you to re do it again error message should not take letters, signs etc onli numbers and if number 0 is entered it should stopped

I need some help with this error. I have some VBA code in Outlook that runs whenever a task reminder goes off. The code is supposed to open a workbook, send email based on the info in the workbook, then close the workbook and quit excel. The task reminders are set to go off every two hours...

I have tried to use the Excel 2000 drop down menu: "Data/Get External Data/New Web Query" and "Browse Web...". I get the error message "To use this feature, you must have a World Wide Web browser, such as Microsoft Internet Explorer." I get the same error message when I enter a known good web...

As an A Level ICT Student, I have been told to push my spreadsheet to as high a standard as I can. I've been asked to find out how to create an Error Message that will show up if a cell is empty when a button is pressed, as we have created an input form type set up. Simple solutions would be...

Whenever I run any of my macros, I get the error message "Code Interruption" or something like that, and I have to press the Continue button many times for the code to finish. The code runs without this error on other computers. I don't think I've changed any of my settings recently, but this...

When this part of my code is used an error report comes up and the de-bugger highlights the pastespecial part. However when the protection is removed from the sheet it is pasting to also removing the "Unprotect" code it works fine?? the error message is.... Run-time error '1004' Paste...

When I delete all the data items from a Pivot table in Excel 2000 I get the following error message: "Excel exe has generated errors and will be closed by Windows. You will need to restart the Program. An error log has been created." I am using Windows 2000 with Excel 2000, when I use the same...

I was getting this error message when I opened some Excel files I inherited: This workbook contains one or more Microsoft Excel 4.0 macros. These macros may contain viruses or other harmful code. Open this workbook only if you trust the source. Do you want to enable these macros? There were...