I've 'attempted' to apply an advanced filter to an excel document, but now I
can't remove it!  The option for a normal filter is 'greyed out' and when I
clcik on advanced filter again, it just shows the parameters.  Deleting these
returns an error, and I can't see to get rid of ...

hi community
is there any method to turn off the prompt...." The cell or chart you are
trying to change is protected......" be turned off whenever user wanted to
modify a protected cell.

I have recently been upgraded from office 2000 to office 2007. I used to use
the routing recipient feature religiously to keep track fof purchases
throughout the company. Is this feature still alive in 2007 or some form of
it? I would appreciate any help....Thanks and have a ...

This macro was coded from here on this site (thanks for everyones help) and
it basically takes all the information from every worksheet in the workbook
and compiles it into one long list of data.
Sub UpdateMaster()

We can possibly hide several worksheets at a time, but is it also possible to
select several hidden worksheets and unhide them all at the same time?

I am currently doing some rapid prototyping in VBA-Excel2003.
Excel is used as lightweight relational database, hence requiring
frequent selection of 'records/rows' based on multiple criteria.
The selections then are transformed into arrays in order to present them in

If I want to trace dependents for multiple selected cells in one go, I can't
do that. It takes only one cell at one time. How to do that ?

I just need a formula to count how many times "ZB" appears in column H.
I've tried
=SUMPRODUCT(H1:H300="zb")
=COUNT("zb", H2:H300)

I know there is a way to use sumproduct to rank with two columns, and forget
how to make the formula... If not too difficult, I would like to know the
formula to make it descending and ascending...
Example

I tried to load an add-in on Excel (currently running Excel 2000) and
the installation looked like it went smoothly, then I added it to the
tool menu no problem, now when I try to run the add-in I get the
Visual Basic error message: 'Compile error in hidden module: This

I am wondering if there is a VBA code to copy a whole cell into another whole
cell and add 1 more number to it. E.G. one cell E19 is 9N08, and i was trying
to put 9N09 into cell F19, E21 is 9S18, and i was trying to copy 9S19 into
F21 etc. for the whole worksheet.

What is the difference between Currency and Accounting number format in
Excel. (Recent release.)

I am copying formulas from Workbook1 to workbook2.
Here is the problem - formulas still reference the old workbook1.
like: Cell(A1) = '[Workbook1.xls]worksheet'!E3
But I really don't want the "Workbook1.xls" I just want

I have data in 4 different spreadsheets. My main sheet has data organized as
lastname, firstname and then relevant data accross the row.
for example:
smith, john, 012345, 78914

I receive this message nearly every time I open a modified and previously
saved file on my drive only. The excel files when I get this message are
usually outputs of my own modules that are created by Microsoft Visual Basic
6.0 under the Visual Basic Editor toolbar.  Sometimes ...