I have a subroutine which calls another subroutine. The child subroutine
has an error mechanism that displays a message and then is supposed to
exit out of the subroutine. Exit Sub only works for the child
subroutine, however, and the main subroutine which called the child

I want to creat a Macro to Print a specific area, while formatting that
information into a clean and visually appealing appearance.
The area is from C2 to I2 and from rows 2 to 91.  When it prints, I just
want to see the information without the gridlines.

Here is what I am using:
Range("E2").Select
   ActiveCell.FormulaR1C1 = "=RC4/R51C4"
   Range("E2").Select

Hello again,
I am creating a workbook with a list of questions. To these questions,
I am going to add a button to "add/update comments".  Each question
will have a button to control comments.  The comments will be stored in

Need some help printing Worksheets.  I have a Workbook that can contain
varying amount of Worksheets.  Currently I count the sheets of a particular
type and based on that count (x) I store the sheet.names in strings s1 to
s10 then select the Case below based on x:

I have developed an application in Excel 2002/XP to handle a
spreadsheet.In order to make the execution faster I want to compile the
VBA-code into mashinecode. The ”Visual Basic Editor” in Excel can only
find compiling errors, but not ”compile”. The application works fine,

Hi all, I have a spreadsheet that uses information from an exce
spreadsheet to open a word document and enter the information a
bookmarks. Then save the document. Now I need -another- button to d
the same but this time open an excel template and populate that usin

Does anyone know how to dynamically fill a list box based on the user's
previous entries?  My form has several list boxes, but I would like to
set it up so that if the user makes a selection in listbox1, it alters
the available selections in the subsequent listbox2.

This is what I have:  
Columns("H:H").Select
   LastRow = Cells(Rows.Count, "H").End(xlUp).Row
   Cells(LastRow + 2, "H") = Application.Sum _

I'm new to Excel VB macros and have a simple problem (I think)
I've got a huge database of a matrix of about 900 X 300.
For a particular row,column, if is an "X", I'd like to copy the header
(top row data of that column) onto another sheet.

I have the following code in a macro:
For Emp = 8 To 63
Application.Goto Reference:="Name"
   ActiveCell.Replace What:="Emp", Replacement:="Emp+1", LookAt:=xlPart, _

Currently, I have a spreadsheet in which I need to calculate the
cumulative distribution function of the standard z, as well the inverse
of the cdf for p(x).
For the sake of speed(?), I am using Application.NormSDist and

I would like to know what is the easiest way to learn vba. I took a class
about a year ago for access and they touched the surface of vba. Is there any
good books to teach a newbie? I know practice is the best way to learn but
how does everyone else learn. Thanks, Neal.

Does anyone know what the proper command in Excel VBA is to "Enter"?
What I mean is that I am programming something in it and the last
required step (so I am told) is to emulate pressing the "Enter" key but

I have written a English VB program for US version of Excel to do several
calculations.  The calculation requires to use the Solver, therefore there is
a reference to Solver.XLA.  I email the spreadsheet to a colleague in
Swizterland, who is using a French version of Excel.  When ...