How do I protect a worksheet but allow a control button to work?
Thank you!

I have the following for...next loop:
-Dim K as Variant
K = 0
For F = 1 To 250

I want to lookup/find a specific value in an array and return that values
index number.  In this case, the lookup list is the first column of 3 column
array.  Suggestions?
DM

ive got two worksheets both with approx 20,000 records of various dat
but they both have a unique identifier (i'll call this ref no.) i
sheet A there is a column named dates which doesnt appear in sheet 2.
have been using an offset(match()) formula to look in sheet a for

All,
Here is what I want to do.   If a cell's character length is more than 38
characters (if len()>38), then the cell gets highlighted red. If not, then
nothing.  I would like to have this were it happens automatically instead of

First, thanks for your time:
I wrote a UDF function that counts background colors. It takes a cell
argument with the background color that I want to count. I work out the
range in the function because the top of the sheet is like a report

  does anyone have a working example of the XIRR function running in
VBA or VB ?
I am pulling what's left of my hair out here. I can run the function ok
but the result is not what I'm expecting. I think I'm obviously going

My VBA IDE Menus and Toolbars are all disabled. I have uninstalled all
MS Office apps, deleted program files\microsoft office and removed the
entire registry key of HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\MICROSOFT
OFFICE. Then reinstalled all products and ran Office Update from the

I am using Excel as a form. Because Excel has a limitation on the number of
characters for each cell, and because I want the text that is entered to fit
neatly into the area reserved for "Comments", I have used Text Validation to
warn the user if he exceeds the maximum number of ...

I have a report to prepare..
Objective is when you click on say button 1 it should show line 6-10
and click on button 2 it should show line 15-20 etc..
Basically they wanted to create you know like have 3-4 buttons and each

I would like to use this code to SUM the total of column G into a different
worksheet. How do I do this?
Thanks.
Set sh = Workbooks.Application.ActiveSheet

I'm sure this is easy, but I'm a bit stuck.
I have a sub that is executed when the Worksheet_Change event fires.  There
is also a macro that I run (mod_Evaluate) while working on that sheet.  Both
sets of code work fine, but...

Anyone have any way to import a csv file that is separated by semi-colons
into a spreadsheet?
I am hoping i can take the file and parse it out by the semicolons and use
the top line as the heading line (titles).

is there a way of clicking on a button that asks you where you want
the file saving, but enters in a filename derived from the contents
of two cells and todays date?
for example if cell A1 contained 'hello' and cell B12 contained

I wonder if it is possible to compile my project on startup.
The problem is, I protect my project with a password. If I switch from
Office XP to Office 2003, it crashes. The reason is, it only works if it is
compiled on the same excel version.