Will Application.AddIns("Analysis ToolPak") work with non-English versions
of Excel?
Are the addin names supplied with Excel language specific?

Hello I have a question about how to get a cell value using a row number. I
currently have a formula that finds the row number of record with the largest
score. I then use the Indirect formula to take that row number to retrieve
more information about the record. Here is the ...

i dont really know anything about macros but i need to insert a command
button into a calendar that, once pushed will insert "vacation" and
background color into the cell that is high-lighted.  
can anyone please help me!!!

hi,
i want to be able to hide and unhide columns in excel depending upon a value
selected and then veryfying whether or not a value entered is correct.  but
the only disadvantage of this is that any user who does not enter the value

See code below.  I know this is pretty simple, but what I'm trying to
do is pull data from a cell (in the test.xls spreadsheet) that has a
varying (based upon what someone writes in the cell) text input.  I
then want the macro I run to reference this cell to select which

My formula in E4 is: =IF(B4<TODAY(),SUM(25+H4),"")
Works great when I put a date in B4.  But - if I accidently put a date in B4
and then delete it, the value stays in E4.
How do I get the value to disappear if I delete the date?

I have 2 sheets.
Sheet 2, which has a data table and Sheet 1, which is to tabulate the data.
Sheet 2 has 2 columns, Type and Delta.
How can I count the number of entry in Sheet 2 that are of Type =1 and whose

I'm trying to create a macro that changes the color of different autoshapes
depending on the values of certain cells.  Each autoshape would change,
depending on the value of a different cell.  So, I need to refer to each
autoshape separately.  When I recorded the macro, it refers ...

I am very much new to write vba.
1.I am having a macro,results of which should refelect in a toolbar list( or
in a fully opened combo box toolbar).How to create a floating
toolbar(commandBar),and display it whenever my w/book opens and closes

I was using the following code to create a validation list in column
A:
Sub rProducts()
      Application.Goto

I can't think of a way but I hope there is one where I can search a
directory of Excel sheets for a function call.  Or ones that use
certain xla files.
Otherwise, I have to pull out my hair.

Hi there. I have Excel 2007 and 2003 on one machine (I am not sure but this
can be relevant). When I open or create any workbook in 2007 and even save it
as a macro-enabled one, I still cannot get to the VBE - it's simply disabled.
I have set all the macro-related options to the ...

Even after unlocking text boxes so they can be edited, as soon as I share the
workbook, the boxes are no longer selected. Is there a way around this?
Thanks!

I developed spreadsheets in Excel 2007 that accesses QB data.  I need to have
Excel 2003 computers access & refresh the data, then run reports.  I also
need to know how to have 2003 access and use the macros I developed for the
sheets.  Where are the macros and ODBC access setups ...

I have googled and searched this group and have not found exactly what i
am looking for. everything i have seen is for performing functions in
the worksheet and not in vba code.
i'll set up the prolbem, explain what i need, and give you what i have