I know that from vba a udf (and any other code called by that udf) may not
alter the worksheet in any way.
However i have an addin from another product, and it has functions that do
more than just return a value to that cell. Does this require a call to a

I have a worksheet with blank rows between each row with text.  Most of the
time it is a single blank row, however between topics there are 4 blank rows.
I want to format the tab stops in the worksheet titled "Data Entry
Worksheet" to jump from cell B5, B7, B9, B11, B13, B15, ...

I have tried Chip Pearson's sorting codes and I can't get it to work on my
worksheet names, maybe it can't be done... My worksheet names are created by
code...the names are as follows:
01-01-06 CSB 18" RCP; 01-01-06 CSB 18" RCP (2); 12-01-05 CSB 18" RCP

Everytime I try to paint the Calendar Control 8.0 (mscal.ocx) on a user
form Excel crashes and asks me if I want to recover my work.  Yet, the
rich text box ocx works fine and my registry is set to allow active x
components.

I am trying to create a progress bar, but it needs to be after LastRow is
defined, so not sure where I should put my bar to go along with this For
Each Loop?  So Basically each time I loop thru the FOR EACH, I would like to
update the progress bar.  I must be putting it in the ...

I am trying to figure out how to make the below VB run correctly.  This code
selects row 1 and then based on what is in each cell, deletes any column that
does not have 1 of 4 variables, is not blank, and does not contain the word
"Name".  Please help!!

I have created a button which saves a workbook as a specified name. The code
is as follows:
Private Sub CommandButton1_Click()
Dim sFileName As Variant

Can anyone tell me if the vba compiler compiles all the code in every module
at once for a workbook, or does it compile the code in the modules as they
are called?
Can I place code that will not work on all computers in a module by itself,

Note sure if this posted properly the first time so I'm repeating it
again:
Hi all
I have written a function to interpolate either linearly or

Hi; Just Wondering;
Does it really make a difference if you don't test for a previous condition
before making a change to a format etc. in VBA?  For example, will I hurt
anything or endager anything if I just do:

In a textbox how do you size the font and center the font vertically and
horizontally?  All I see is where you select the font.
Thank you,
Steven

i have a table with group #s in column A and values in column B.
i am using the formula below to calculate the average value (ignoring nulls)
of the relevant group on each row.
if i add a weighting in C1:C10 how do i calculate the weighted average of

Hey MS people, you really ought to include a better language for
scripting Office than VBA.  I'm sick of typing 'End If'.
May I recommend PERL?
It's really amazing how fast you can code something up in that

This is a two part question.  I have created several macros to run on a
spreadsheet.  
Q1 - how do I combine all these seperate macros to run sequentially together
at the press of a customized toolbar button. ( I know how to create the

How to execute a parametrised stored procedure from MS query to MS SQL
database? If it's possible.
Regards
Otto