Hi *,
in my C++ program I write programatically (by COM interface) OPC measured
values into Excel cells. In order not to disturb the program write
processing I need to disable user´s range selection change during the

I have a spread sheet with a GetPivotData formula, where I also have an
if statement that replace 0 (zeros) to "" empty cells. This replacement
is critical for some formular to work, but it also make the black cells
not usable for any calculation. If I simply multiply one empty cell ...

Hi once again,
This code works good save for one problem. When I exit Excel, my menu's
don't return.
As you see I have tried both the "Deactivate" and the "Close" events but I'm

=IF(AND(VALUE(AL237)>=14,VALUE(AM237)>=12,TRIM(UPPER(AN237))="S",TRIM(UPPER(AV237))="T319",TRIM(UPPER(AJ237))="Y"),IF(VALUE(AZ237)>600,600,VALUE(AZ237)),IF(AND(VALUE(AL237)>=14,VALUE(AM237)>=11,TRIM(UPPER(AN237))="P",TRIM(UPPER(AV237))="T319",TRIM(UPPER(AJ237))="Y") ...

Hello---
I wrote a series of macros for my office this summer and distributed
them to many machines using an add-in. Everything was working well
until a co-worker got a new computer. Now, this line of code seems to

------ Hi i am having a lot of trouble with the following piece of
code.
ActiveCell.FormulaR1C1 = _
        "=TTEST(sheet1!RC:R[50]C,sheet1!R[51]C:R[100]C,2,2)"

I am working in a sheet with 2 different data validation cells, named as
ranges "DV1" and "DV2" respectively.  The only values for the cells are "Yes"
or "No".  When one of those 2 cells changes, I want to hide or unhide other
sheets, based on the value in the changed cell.  The ...

Please advise on what the best strategy is for this situation:
Column A is Sales Type, Column B is Client Name
If select "New Order" in Column A, I type a new client name. If select
"Renewal Order", I want to see a list of existing clients.

in early version of excel, you insert a new dialog box worksheet with the
Insert/Macro/Dialog command. In excel 2003 what is the comparable command?

The VLOOKUP(A8,InputSheet,8,FALSE) embedded in the below array formula
is supposed to retrieve a name range (dependent on criteria in that
particular row of data) and return data contained in that range.  But,
the formula output is only recognized as a text string and not as a

I have a setup of a manually entered grid of data with 40 rows and 12
columns.  Each week I need to update Row1 Col1, move to Col 10 and enter
some data, then on to Row2 Col1 ... Col10, etc...
I would like to code the following...

I need to count the number of disconnects, "D"s, in for each employee in the
month of x.   Each employee info takes a total of five lines.  The row
indicating the month is two lines above the type, where the "D"s would be
located.  The formula will be on a different sheet than ...

i have protected my sheets using Userfaceonly:=true (in workbook open event
procedure).
Some subs trying to copy ranges from one sheet to another keep getting an
error that i should unprotect my sheets first. I think this must be some kind

I want to be able to have scroll bars within a particular cell within a
table, as this table will be viewed on the web.
As one cell is going to contain considerable data, and some of the other
cells will not, I want to be able to have scroll bars to some of the cells,

How do I round to the nearest 25 cents in Excel?