The following code takes 4 seconds per cell to complete the four lines
between Message Box C and D or between D and E. These lines total from the
current worksheet (Calc4) into another worksheet (Summary). I have tried to
tune the code as best possible. If anyone knows of a ...

I want the following workflow module:
A + B - C = D
A     B     C      D
10   10    05  = 15

I've just converted and old Quickbasic program into excel but i'm stuck on 1
problem which I'm not even sure can be done. I want to call and run an MS DOS
batch file from within a VB macro.
Precisely the batch file is called "importdatafiles.bat' and all it does is

I am fairly new to VBA and am working on a project where a simple Object
structure could be useful. Most of my previous scripting has been with php
and javascript, both of which blur the distinction between Classes and
Objects so I am pretty fuzzy on it myself.

is there any code that will allow me to retreive just the values of the
number and ignore whether the value is -ve or +ve.eg -3 return 3, 3 return 3

I have a few text boxes on a userform that display values for allowances,
however $10.00 displays as 10 with no "$" and no 2 decimal values.
Also a 0.09 is displayed in another textbox, however i want it displayed as
"9%".

Code that solved a previous post from Tom for me:
~~~~
Dim sh as Worksheet
for each sh in Thisworkbook.Worksheets

having trouble consolidating the different values from 10 columns on 10
sheets to one neat list on the 11th sheet without having to sort them after
they are compiled.   Is there an auto sorting way for consolidating?

I have two MODELESS UserForms and I need to have the Textbox1 come up with
the Focus when UserForm2 is Activated. Also, I need to leave UserForm2
Loaded so I just use SHOW and HIDE. The PROBLEM:  When UserForm2 is LOADED
(Button1), Textbox1 DOES come up with the Focus. However, ...

I have a folder that contains numerous excel files.  What I would like to do
is loop through the folder and make all the files read-only with the
read-only password being "test".  I can create the loop code, I'm just having
trouble with the read-only piece.  Can one with more ...

Dear Reader
I  using UsedRange.Rows.Count to find UsedRange row number.
Sometime, I need adjust the value. Do you know why ?
How to delete all the rows in worksheet. As a result

I know there's a million posts here on how to do this but since I'm such a
newbie, I don't know how to modify them to my explicit need.  
I have a spreadsheet where I need to delete each ROW where the total in
Column O =0.  I need to start the macro on Row 15 (due to headers) and ...

I'd like a User Form to make the same beep as a MsgBox makes when it pops
up. I tried the word Beep in front of my User Form show, but I got no
sound.
Don <www.donwiss.com> (e-mail link at home page bottom).

I'm trying to position Comments above the cell they relate to.  When running
this code, (trying different numbers for Top, Left), the comment only appears
repositioned when I right click the cell and click "Edit Comment", i.e. in
edit mode.  Thus, the code isn't working.  I need ...

I have this code that suppose to doa Save As Action,  it goes trough
the motion,  but no file is saved.
' Start Save As File Prior To resetting
   Msg = "Save File Prior to Resetting the Form!"