My VBA looks for a cell first, then Selects another Cell in the same Row, and
then puts a Formula in the Active Cell,
and then I have a Problem trying to Auto-Fill this formula;
When dragging the Formula down I need to define a Range starting with the

This is part of a larger macro. What i need is on fridays after 3:30p for the
date in my textbox to goto the next work day. any ideas? Any help will be
great.
With Me.qcDte

Is it possible to make a workbook "undeletable"?

I need some help with the following code, please.
I have a big number of Excel workbooks saved as follows:
H\Drive: Main Folder  (containing the following subfolders):
                 SubFolder 1

I have a VBA application in Excel that opens 100 workbooks.  It works fine in
Excel 2003.  But in Excel 2007, it fails half way through with the error
message "Not enough storage to process this command."  Both machines are
running XP, and the pagefile is set to the max 4096meg.  ...

Code for Voting and importance works great. Thank you
How about the Delivery option? to return responses to group mailbox
and how do I set the send response option with
EDIT THE RESPONSE before sending option selected

I'm getting a type mismatch error on the following section of code - any ideas?
========
Set wsDest = Workbooks("NI Insurer Market Share as at " & Format(Date,
"yyyy-mmmm") & ".xls").Worksheets(Array("PC (Chart)-NI-MONTH", _

Ron's Code is greaqt --new at programming excel.
The code you give in MSN for send mail is great I need to automate
one more option from outlook, the voting options
Want to add automatic message options option to Ron's code

Hi folks.
I have code in my auto_open macro to hide all the excel toolbars and menu
bars to give a clean dictator program appearance.
I also have included in the auto_close macro the code to re-show these menu

I need a formula that will show the last cell in a range.
1000
2000
3000

Ok, I understand that I can skip the "Do you want to save..." warning by
setting ThisWorkbook.Saved = True.
And I understand I can abort the Close by setting Cancel = True.
I need a better understanding of the order in which things occur because...

I am currently using this connection string
Public Const ConnectionString As String = _
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
Settings\desktop\test.mdb;Persist Security Info=False"

5
Hello,
I have a spreadsheet that has numbers in column A and Text in column B.  I
would like to indent Column B based on the value in Column A as follows:

I'm quite confused over the different News Groups (NG's), for example, what
is the difference between the following two:
http://www.microsoft.com/office/community/en-us/default.mspx
and

Is there a method of making a command butoon visible on all worksheets
without creating a new object on each sheet?  I've put it in a userform, but
then I cannot navigate between sheets without closing the form.