I know I can use Excel worksheet functions in VB.  My question is when one of
the parameters of a function is an array.  Can I used an array defined in VB
code (instead of the usual worksheet-range input) as the argument for this
function?  Thanks.

I'm new to arrays.
I have attempted to create a 2D array for the following data in my
sheet. ("Joe" is in cell C3)
Name    From    To

I am trying to use the Excel Subtotals function for a scenario where the
number of columns needing to be subtotaled varies -- there may be 4 columns
in one run of the code, but there may be 20 columns in the next run.  Below
is the recorded code I have tinkered with -- but I am ...

I need a fix to select only the 4 right digits in cells that are not empty in
a column (Range J2:??)
Thanks -- Suz

I have a problem on hiding a row when the value of a cell changes.
The following macro which works if i manualy input a zero value into the
cell, but when the cell is a formula and the result is zero, it doesent work
anymore.

I recorded the following code for adding a scrollbar to a sheet.... no
problem. So I cut and paste the code into my module and it runs fine.  
However what I can not figure out is what OBJECT varriable I can use with
this statement so I can use the object varriable in the WITH END ...

I had posted on this issue previously, but was not able to find a solution
from those who provided input.  Below is a better description of what I'm
trying to do and the issue I'm having:
I am trying to get the code to subtotal beginning with column BA and going

I posted this in another forum, but because there seems to be no other
information on the topic i felt it would be beneficial to ask here as
well. (link to original post:  http://www.excelforum.com/showthread.php?t=626117)
What i'm attempting to do is edit a Microsoft Project file ...

I have two userforms, form A and form B. Form A contains 10 textboxes
(txtbox1, txtbox2, ..., txtbox10), and form B contains a combobox and an OK
button.
What I want to achieve is as follow: whenever the user click one of the ten

I am using a case statement that where a condition state exists, a column of
values are populated for a specific month using:  range("AI7") =
Range("J97").  I have about 30 of these statements, for twelve conditions.
Problem:  this takes a long time to execute.  Is there a faster ...

What would be the appropriate piece of code for using the feature of TAB,
within a selected range.

Now have a little other qst:
I have this web page attached, i want to find the word "Trovati:" and get
the value near tath in this case is: 827 , after store 827 in a cell of sheet.
tath is all.

Hi friends,
One of the reputable experts advised me to use the following code to return
the color index of a cell:
Public Function Color(ByVal rgeCell As Range) As Integer

I have a report that's exported to Excel.  I want to take that report, copy
it into another sheet, change the formatting a bit, then... run a macro or
program to take the values in certain cells, look them up in an array I've
created on another tab, and replace the value with the ...

I have a spreadsheet which has been created on another computer, and I am
having problems setting the column widths. My version of Excel 2003 is set to
use a default font size of 10. It appears that the computer the sheet was
created on, had a default font size of 12, because if ...