Is it possible to check the length of each item in a specific field in an
array? Is so, how?
I am building an array but I want to check the length of a specific field
for each item in the array.  For example, each "record" in my array has 4

i´d like to know how to call a sub inside other sub.
If i have a sub that a user can trigger by clicking a button, i´d like to
call another sub in the middle of the code. In a pseudo-code example that
should look like:

Several days ago, I posted a couple of messages about this subject, and have
not gotten any responses that help resolve the issue, so let me repost.
I have an Excel application that is using a Userform to capture data and put
it into a hidden spreadsheet (this works great).  As ...

How do I reference a form that is located in an add-in xla file?  The name of
the xla file is dailymods.xla so I tried:
dailymods.userform2.show
but it doesn't work.  Ideas?

Help please, this is driving me mad!
This is a simplified version:
          A        B       C       D         E         F          G
R1    Code    Open   In     Out    Book   Physical    Diff

I've looked around and tried to apply the examples listed here, but I guess
I just don't get it.  I have a line of text that I'm parsing for inclusion
into seperate cells in a sheet, one of which should be a hyperlink.  When I
try to paste the info into the appropriate cell ...

I know that Excel will allow separate formatting of data within a cell
(i.e. "37715CCC", where the numbers ("37715") are "blue" & "bold" and
the letters ("CCC") are "black", "bold" & "italic") ., but is there a
way (VBA) of going thru a selection of cells, finding the letters,

I am working with a workbook in Excel 2003 that has over 40 tabs
(worksheets). Each worksheet is a department report and each department has 4
reports. The last report is the one I need to select for each department and
copy it into a new workbook. The name of the worksheets to ...

I am trying to create two buttons that, when either is selected, will run a
macro to populate all fields in that column with a "Yes" or "No" depending on
what button they clicked on.  Let's say the "Yes" button is placed in cell
A1, and, if selected, all fields from A2 on have ...

Whats the easiest way to do this I am having a hard time trying to
figure this one out :( Please Help!!!
Private Function CheckedSummons(StringtoCheck As String)
Dim cnt As Integer

How can I find out if the ActiveCell is one of the cells in a named range? In
the SheetChange event, I want to take an action only if the cell that was
just changed (Target parameter?) belongs to a certain named range.
Thank you.

In my project we have exporting to Excel capabapility. What we used to do is
generate HTML and set content type as Excel. This worked great for 2003. When
I open the file in 2007 I get a security warning.
Does anyone have any idea, how can I make the warning dissapear?

I've got a huge file from which i'd like to delete to some rows but I DO NOT
WANT TO OPEN IT in order to avoid having to wait a long time. So, is it
possible to delete some data (using vba) from an excel file without openning
that file?

What code could I use to select cell A1 in the last sheet? I have
variable quantities of sheets and the sheet names can be changed. So I
guess its something like Worksheets(xxx).Select, but how do I know the
last number?

Is there any way to implement a user defined function for use in spreadsheet
cells using VSTO? Is it possible/neccesary to use a vba add-in to make a call
back into a managed VSTO app?