I have been using a large macro in Excel 2002 for some years now. One
step in the macro consists of creatng a formula.
An expression for a formula, using labels, is constructed as a string.
This is then converted into a formula by,

Excuse my extremely novice post, I've been looking through google
groups to find the answer to my problem but haven't got very far..
I want to simplify the below IF statement:
Private Sub CommandButton11_Click()

Anyone come across this before. This code has worked fine in the past, but I
have one particular sheet which behaves very strangely.
I have
Dim ThisRow as Range

Unfortunatly, I don't know how to go about doing this.  Currently I have
a list of rows, where the user scrolls to the bottom to enter new
fields.  He enters four fields and then copies down about 10 formulas.
What I need:

Hi, I have some code which copies a sheet to a new workbook. Is there a
way to exclude command buttons being copied to the new workbook?
Thanks,
Dean

I'm having a problem with the following function.  For some reason, th
function returns before the first MsgBox call.  It succesfully delete
the column, but it exits right after.  Any help?
Code

How do I get a Macro to open a password protected workbook without prompting
the user for it? I have several users writing to the same file via macros but
I want to keep their information private from each other.

I am trying to capture the range a user selects then put that
information into a textbox in a userform.  That's the start cell and
end cell addresses, not the contents.
I have a Userform with an Excel workbook.  The user is going to

Excel 2003
Visual Basic 6.3
I have a form with 24 text boxes.  The names of the text boxes all
start with “txt”, e.g. txtCHOL, txtALB, etc. The values that are

Is it at all possible to create a text file, so that when any user opens
a particular spreadsheet, their username and current system date is
appended to the text file?
I'm inerested in creating an access log for one of our spreadsheets.

I would like to create an Add-In or some other method that would run some
code when every workbook is open and when every workbook is closed.
I am aware of the Workbook_open event and the beforeClose event but how do I
program my add in to run code at those times, for everything ...

I'm writing a macro to update a notification cell (B10) to indicate when the
worksheet has changed.  The following code works:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim CurRow As Long: Dim CurColumn As Long

Hi
Is there a way to automatically set the Font to capitals, or UPPER, for
all text inserted in certain cells...
Or do I have to use an on event, macro that changes the text to UPPER

I am not making this a reply to the jerk who has been posting the msgs about
illegal immigrants all over the place, because I don't want to do him/her the
favor of opening one the msgs & having to see it.  I don't know whether I
would agree with whatever they're saying, but it is ...

Can anyone give me some help with creating a random number array in a
very specific way?
First of all, in the cells of column A, automatically create a simpl
sequence of whole numbers, increasing from 1 to y, where y is anythin