Is there anyway to permanently lock the "Group/Ungroup" feature so
that it is permanently inoperative.
It is a pain in the a.s.
Paul

I have the lookup function:
=LOOKUP(A3,'Item Price List'!A2:A1726,'Item Price List'!D2:D1726)
which finds the value in A3 on another worksheet in column A an
returns the value in that row in column D.

I have this macro.
-----------------------------------------------
Sub LockEm()
Dim Wk As Worksheet

I'm using Excel 2003.
I'm pasting some data from an ASP.Net datagrid into a worksheet. One column
called Duration could have a value of 11:31 in it - which means 11 minutes
and 31 seconds

I am compiling a hours worked sheet. I have assigned a button whic
adds 7 to the active cell, what do I have to do to get the active cel
to move one cell down in the same column so I do not have to manuall
move the active cell down.

=AND($D$3="Y",EXACT($D$3,UPPER($D$3)))
I  would like to be able to put a "y" in any cell in column "D"
and have the same cell in column "E" turn  blue
can you help me set this up

Is it possible to conditionally format for rows containing certain
text?  I receive a weekly report of hours and costs from our financial
department that I need to sort and enter information into a
spreadsheet for actuals vs. budget.  This information comes to me with

I've searched the forum on sorting and can't find this problem. My shee
in Excel 2002 has three rows of data that serve as column headings.  
need for others to be able to easily sort using the toolbar sort keys.
When I do this, it doesn't recognize the column headings and sorts the

I am trying to achieve the following. Is this possible.
I want one range variable in the formula.
Eg. =TestRange(RangeReferences as range)
Can I have 1 range variable but insert numerous separate range cells in the

i have office XP installed on my computer at Office, i
have winXP , i made password for an excel file and i
forget it , how can i know that password again , is there
any programm to crack it , so please for any body how can

I'm trying to use VLOOKUP to determine which row in a table corresponds to
my data value (or return #N/A if it's not there).  All goes fine, except
when the data contains a "~" - which appears to be a special escape
character as far as Excel is concerned (see example below).

how do i change the color of a cell (red or black) depending on if an
X is present in a range of cells please?
        a          b         c             d
1     tim

I have a file that is monitoring and trending external data. I have a type
of animation that occurs based on the data (very simple graphics using
fonts, colors and conditional formating). Similarly, I have tables that have
cells changing colors to reflect the type of value in the ...

a question for a Friend of mine..hes wondering if theres
any way to Automatically number his invoices e.g. invoice
0001, invoice 0002 etc instead of numbering them
individually?.  (we are both Newbees to computing)

This will turn out to be a foolish question, but I have to ask...
I have a userform with 7 textboxes for users to enter values in.
The values are limited to 5 characters and are meant to represent working
hours, e.g '8', '4.25' or '10.5'.