My Macro does not DELETE the ROWS from the specified Worksheet whene SAVESTR
is NOT Found.
If SAVESTR is found it deletes the other ROWS.  However I need to be left
with a blank sheet if SAVESTR is not found in the specifed column.

I use excel a bit, but I am still learning.
Here is the thing I want to try to do:
I have a product that costs X amount I want the said product to have a 35%
total clear profit after VAT.

This is a simple problem or it's not even possible, but I have some
code like
pt_1=worksheets("Sheet1").range("a1")
and I need to be able to use code to paste to this location using the

I wasn't really sure how to phrase this one -- this isn't your Typical
Drop-Down List.
I have a SELECT statement which queries SQL Server 2005 and displays the
data in Excel.

I get this when I sign on to any of my 2007 programs on my new laptop....
at the top of the box it says BCM Office Addin

I'm having trouble getting two labels on the X axis. My data is such
that there is a subject's name and then two different situations for
that subject, each with a pre- and post-score. So, for each subject,
there are 4 histogram bars in 2 groups of 2.

When I point to a cell to drag it or add a list of consecutive numbers or
drag my formula to adjacent cells  this *&^@^ star appears instead of the
usual pointer. It messes up everything , Please tell me how to get rid of it.
----------an octegenarion amateur!

I want to write more than 29 array varibles (defined in a my VBA code)
in a workbook range. Is there a way to accomplish this?
Here is my sample code (check my remark):
Sub ArrayTest()

Would appreciated any help on this.  I'm looking to create a
spreadsheet that can generate weighted random numbers much like
professional sports leagues do with their draft lotteries.  I play in
a league with 20 teams and we have a draft every year.  I would like

I have a field named Product_Code in my database. Have another field called
country_code, and a last one named Shipment_Amt$.
My draft formula is:
=sumproduct(--(Product_code=B15), --(Country_code=$C$2))

Can anyone help please?
For some reason i am no longer able to scroll across a cell by moving
through teh arrow keys.  The whole sheet moves instead.
Can anyone tell me what I ahve done to lose this control please?

I have wrote a program for reporting dashboard and faces 2 issues. One is
end users macros security is set at high level. Second issue is end users
disable macros. How do i force end users to enable my macros if any of the
above occurs?

This formula results in a numeric result:
=SUMPRODUCT((A1:A20)*(B1:B20="b"))
but this formula results in a #NUM! result:
=SUMPRODUCT((A:A)*(B:B="b"))

There's a sheet rock made for sound reduction.  It's called Quiet Rock.  The STF rating
doesn't care much about low frequencies -- just speech range.  Thought you'd be interested.

I would like to calculate values two cells against dimensional tolerance.
Example, Cell B2 has a base line value of 2.000. Cell C2 has the actual
dimension, lets say it's 2.004. In cell D2 I'd like to display "PASS" or
"FAIL" if the value in cell C2 is greater than or less than ...