I've been working on this for the good portion of today and Im very baffled.  
I'm probably overlooking something very simple.  Anyway I need to get the mod
of some very very large numbers.  So large I need to split it down into
smaller componants just to load it into a double (Im ...

A user would like to have cells limited to a certain length of input, but not
have an error message displayed if the length is exceeded... just keep the
text up to the limit, and prevent any further entry.
With Data Validation, if you uncheck the checkbox which tells it to show ...

I am using Excel 2003 Pro on XP Pro.
I have a class module (ICustomSheet) as part of my VBA project (which I
have named BOC) which has the following simple definition;
 Option Explicit

My Dearest Wizards,
Col A is the dates of the year from 1/1 to 12/31
Col B is the initials of my 11 randomly scheduled salespeople ab,bc,cd,de,ef
etc.

Does anyone know how to copy a diagonal matrix into one column.
Example:
1 2 3 5
5 3 4 7

I'm creating my very first VBA form (Im a Newb), but I'm wondering how
to get the number that is typed in a a "textbox" to immediatly alter to
a negative amount when it is submitted and populates into the sheet?
Thank you,

...not in 2003
I set .left = 1 and .top = 1 and it works fine
in Excels other than 2003. There I get error 1004.
Can anybody help with that porblem

I have a macro which requests a password before allowing one to change a
worksheet. I do not want the password to be case sensitive. My code follows:
On error GoTo Error
If TextBox1.Text <> "groupproject" Then

I am looking for a way to temporarily remove a cell or cells from a
summed column without losing the contents of the cell.
Something similar to, "if A9>0 then C9, E9 , G9 =0" and then be able to
restore the original contents of C9, E9 & G9 by returning the value of

Is it possible to get the properties of a folder/drive from within an Excel
macro and then populate seperate cells with the folder/drive size, number of
files & number of folders?

I have an opened workbook which was saved by a user.
Now I need to treat this workbook as a new, so after clicking File/Save
 (not Save as) Excel will open dialog window to provide filename.
Is there any way to do this from VBA?

Hello Programmers!
I need some help with this code. The way this code is set up now, is
that it saves the file from the users input. I want to modify to save
from cell F2 from a sheet call HH1. The code to modify is in red.

I would like to set the correct printer using Visual Basic. I tried to record
the macro with changing the printer and it shown something like this:
Excel.ActivePrinter = "My printer description"
But the problem is that I don't know the exact description of the printer

I'm having some trouble with consistently getting Excel to fire the
newWorkbook event when I open Excel.  It seems that on some computers,
opening excel (which opens book1.xls by default) invokes the
newWorkbook event while on others, it does not.  This doesn't appear to

It comes up with runtime error 13
Someone very kindly did this for me (because I dont know VBA) but can
get hold of him to help fix it. It chokes on the P5 thing when i
should be looking at cell P5 then going to the sheet named in tha