I found (at http://www.ozgrid.com/VBA/excel-add-in-create.htm ) the
following code on the net and i'm trying to use it:
When adding the AddIn , i get an error message 'Invalid procedure call or
argument'

1. Imagine this scenario: You have a company which has 1000 employees,
organized in 10 work locations, and 50 workgroups. Each work location
can have 1..N workgroups, and a workgroup cannot span multiple work
locations.

I have a spreadsheet which contains a Combobox with an Index function to
display information from the selected record of another worksheet.
I have created a Form with a picture object and have added the following
code to the form:

Hi all, i have many rows with the same number in column A and i am
filtering column F for the criteria "ZA-T-M-*" which is working fine.
However i need somehow to delete all rows with the same number in column
A. The second last row has ZA-T-M-* in it so all rows with instances of

I have a line in a text file in wich I want to replace some text.
I read a line of the file, check if it is the line to be modified. If
it is not than I go to the next line and so on till the end of the
file.

I have never run into anything like this,
I looked into excels help on programming find and replace functionality,
they offer the following code:
With Worksheets(1).Range("a1:a500")

I have about 30 columns by about 5000 rows with data already sorted by column
S (Assy Code) . I need to compare that number ex 5000-01,  from column D
(Assy Code - may be in the number format XXXX, XXXX-XX, XXX……) with column S
ex 5000-01. If that number is equal then I need to ...

Can anyone help to make this work:
Sub CopyAndClose()
   Dim filex
   filex = Range("Sheets2!F2").Value

To all,
I have a macro in a worksheet that I want to run when any data in
Column B changes. At the moment it is run by a button click. Is there
anyway to do this without rewriting the macro?

I sometimes get the error "The object invoked has disconnected from its
clients" when my macro tries to import TXT files. There seem to be many
different causes of this error posted in the forum. Any suggestions about
what is going wrong in my case?

I am adding worksheets to a WB using the above line.  All I want to do is
add a new wks after the last wks in the book.
The  line of code work for the first 16 iterations but causes a [Run-time

I have a textbox for putting in Employee ID. The moment I enter the
employee ID and tab out of the control, there is a validation being
done. If it is an invalid ID, I get the message box but the curor moves
to the next control. How can I take it back?

Dear Reader
How to amend formula ?
If existing formula is =Round(E1+F1....+Z1,2) , how to amend to
=Round(E1+F1....+Z1,2) + 0.02 ? Where 0.02 is Roundup different value.

Hi all.  Does anyone know if there are character limitations on Vlookup or
Sumif formulas?  I have a file where the cell I am looking up is quite long.
And I seem to recall a while back that vlookup only reads the first x
characters in the lookup cell.  Is this true?  Thanks for ...

I have an userform (Name=MyForm) with lots of controls. Two of them are
Employee ID (Name=aEmpID) and Employee (Name=aName).
I have tried lot of things in the Private Sub aEmpID_AfterUpdate() but
not successful. What I want is, if I enter the employee ID, it should