L.S.,
I have an Excel Workbook with a VBA Project containing 2 User Forms
with each a Command Button.
User Form 1:

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
In one of my Sub's this Paste-function only work every second time.
Can you help me to make it work -every- time?

How can I locked one column in worksheet?
Click on the column, ask password input, if match edit the column.

My workbook has worksheets for each year.
In each worksheets is a list of papers published in our department.  The
columns of each worksheet represent Authors, Article Title, Citation
information.

How populate array by sheet data ?
example:
a1 = "mary"
a2 = "john"

I created a macro that will autofilter for certain records.  I was thinking
of creating a query but the autofilter will return only the records
specified, correct.  If so, then is there a way to write within the macro to
display a popup for prompting for criteria that would be ...

Excel 2000 / Windows 2000.
Connected to an MS Active Directory network.
I need to find the login name of the user running the Excel VBA macro.
This is NOT the same as "username" returned by VBA.

I must be blind. Please help me find what's the problem with this code.
I get the following error when I run it.
"Run-Time error 1004: Application-defined or object-defined error"
My code is really simple and yet I don't know what's wrong with it.

Hi All...........
Is it possible to select a named range, and then cut or delete all Drawing
Objects located within that range?
I do not know the name of the Drawing Object, as Excel assigns a new name

I am trying to modify Ron de Bruins code to open all files in a directory.
Sub Example2()
   Dim MyPath As String
   Dim FilesInPath As String

Can you have userforms in addins? If so how do you call them from a workbook.
I have a button on the worksheet that executes
Private Sub cmdMain_Click()
'*** Shows the main menu ***

I have a blank template that is used for Purchase Orders. Once completed, it
is renamed and saved under a specific job folder. I would like to link this
template to an Order Entry Log (as it is called) so I have a running list of
items ordered. The Purchase Order template and the ...

I have a 4 functions that work together
Function 1 will prompt the user for a yes\no answer and if yes will run the
function and then move to function2 and if no will move straight to function
2 and so on, the problem is function 4, if I answer no it returns to function

I need some help with a macro to insert one row at a point where there
is text in a particular column.
The worksheet has multiple columns, but the two relevant ones are
headed Category (Column A) and Tasks (Column D). Each Category

I have a column that I need auto filtering to the top ten values in say
column/range A10:A100. I'm looking for code to do this. the code should begin
with removing all filters and then re-instating them so they are back to an
unfiltered state. I don't want my users touching the ...