I'm working on Excel 2000 on a W2K machine.  I am currently putting
together a data entry sheet, on which there is 1 textbox to allow a
lengthy entry to be both visible and printable.  However, in the
background I have a hidden sheet which collates all the data in

have the following macro built with excel want to stop in (A2) to enter text
then return to M132. This is test range to establish function Have (A2)
formated for given amount of text. Not sure of code to allow text entry Runs
thru without stop.

To password protect a sheet I use a very simple piece of code, as
below, but how do I incorporate code to ensure that the "Select
Unlocked Cells" is UNCHECKED when protecting
Sub Protect()

Can some one assist me with the following:
I want to create a macro that deletes all lines that contain a certain
value in column A.
For example

I'm just trying to make sure my understanding is correct here:-
Is Nothing a 'value' an object variable can have. I'm an old 'c' programmer
so my guess is it's like having a null pointer?
My guess is that Empty means that the object exists but none of its elements

I have a sheet with values similar to this:
148    407    118
118    10003    169    364    15
15    222    67

Is there a way to sum the range, or array, C14:T22 over an increasing number
of worksheets, displaying the value in the same cell of worksheet "Totals"?
Regards
Dylan Dawson

I am in requirement of your expert help. I have multiple files in a folder
which have exactly the same formats, Sheet names and structure. I need to
summarize the data in a new file extracting the data from each of the files
in the folder.

I am getting anerror with the below code:
Is there a way i can get it to use the ActiveCell that triggered the macro
here ??
Private Sub ComboBox1_DropButtonClick()

Hi All,
I'm writing a function that counts the number of rows that match a composite
criteria. A set of criteria is passed in the function's arguments. See
example:

Please send me an example code to get the last record number in a worksheet

Hello! I am having issues with the following code...It seems that my
statment below isn't working the way it should. Here is the
situation... THE < ans, > ans, = ans is the problem. I need the code to
only match the TRUE completed value of TextBox3... I applogize how

I want Excel to background colour a cell, Red, Amber or Green dependent upon
the data in it compared to the data in the cell immediately left of it.
e.g. if the data is equal, or lower value = red
if the data is higher by 1 = amber

Can somone please help me with this program.
I enter Tool Descriptions in Column 3 in my spreadsheet by selection from a
DropDown Validation list.
I also have various combinations of the tools which I select from the list

Forgive my utter ignorance of VBA......years ago I used to do quite a
lot of Excel programming with the old "Command Macro Language", but
never got started with VBA.
However, a project has arrived that requires me to create an Excel