Hi;
I have very large datas in column A & B. To get what I need, I create
PivotTable. But I have to do that manually each time the datas in bot
columns changed (on a daily basis).

I am needing to have VB code place text into the comment box of a series of
cells.  Currently the text to be placed is being retrieved from other areas
and being held in a array.  At the conclusion of another routine it needs to
be placed on a comparison page for comparing a ...

What is the function to end a Do While statemnet when encountering a null,
blank or empty cell?
Thank you
Dave

I want to convert an older xls file to xml.  I can save it as that but it
doesn't display properly.  What can I do?

I use excel driver to retrieve the data (not allowed to use excel object
libaray), the worksheet name seems cannot contain any space(ie. "worksheetname"
but not "worksheet name") . Is this can be solved ?
   cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel

I have a fairly large add-in that has had a lot of people's hands in it.  I
was wondering if anybody knew of a utility that would analyze the add-in to
try and find unreferenced Subs and Functions?
I say "try" because I understand that the kind of static analysis such a

I need call functions defined in XLL AddIn from VBA, but all arguments in
addin function are defined as LPXLOPER. I guess some of them have to be
mapped to String type of VBA, some to Integer, maybe some to Varian, but I am
not sure. How can I find out right mapping of types?

I recorded a Macro while using "Data/Get External Data/Import Tex
File".
The Macro is:
______________________________

All,
I had a workbook with an Auto_Open procedure in it that looked for selected
information within the workbook (like a sheet named "StartUp").  If found,
then the Auto_Open procedure would run.  

Is there some way to dragdrop cells from on workbook to another?

Sheet1.Cells(11, col_Safety).Value = "=IF(INT(F11)=1,("
+ Sheet1.Cells(7, col_Safety) + "+(MOD(F11,1)*"
+ Sheet1.Cells(7, col_Safety + 1) + ")),IF(INT(F11)=2,("
+ Sheet1.Cells(7, col_Safety + 1) + "+"

It seems my previous attempt at asking this question has cause
confusion
I am using personal.xls to store macros, like most people
One of the macros I have, checks any loaded workbook for certai

Good afternoon ,
 I'm lost . . .this bit of code is used in a 'call.'  it works fine in the
body of the program, but does not work in any of my 'calls.'  why???   I've
tried just about everything (except reboot).  Still a rookie here, but I

I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
1024M.  I am trying to transpose some rows and columns and Paste Special is
grayed out and unavailable.  Is this a problem with Office, Excel, XP(home),
or ?.?  Is there a work around without reinstalling ...

How do I find out what a user selected from a combo list. For example, if the
combo box list is A, B or C and they select B is there a way for me to
determine that in a macro.
Thanks!