Search:

Just my 2 cents:

Every once in awhile, this happens to me. No rhyme, no reason.

When it happens, I go to:
Tools/Options/Calculation tab.

Somehow, the "Manual" radio button is checked.
...

Thank you so much Deborah - it works perfectly now !! Much appreciated.

Michael

Using Windows XP/Excel 2003.

I have attached the spreadsheet in question (which will actually have ten tabs similer to these)..
What I want to do, is be able to type in the Date (manually) for...

Oops, I'm sorry, I should have seen that. Since you separate the names with semi-colons, you should change the line

ARR = Split(Recip, ",")

to

ARR = Split(Recip, ";")


That did it !! ...

I am so sorry for being a PITA, but using the below code does put both names into the TO line of the email but when Outlook opens and I click send, the same message appears:
Microsoft Office Outlook...

You should obviously remove the line

EmailSend.Recipients.Add (mYRecipient) 'first add the email or user as a recipient


Obviously !! ...

OK I am getting closer.

I moved the code:

Now when the email pops up, it has both names TWICE.



Private Sub SendMessage(Recip As String)

There's some confusion here because you and I use the variable Recip for different purposes. Change the line

Set Recip= EmailSend.mYRecipient.Add(arr(Counter))

to

Set objRecip=...

You'll have to modify it to fit in with the your own code, of course.
Of course http://windowssecrets.com/forums/images/smilies/smile.gif

It is getting stuck asking for "Object required" on...

You have to use the Split function to create an array of recipient names, and add them one by one. The code of the SendMail function shows how to do that:


Function SendMail( _
Recipient As...

The SendMail function in the attachment to Post 728849 shows how to handle multiple recipients in a string, separated by semi-colons.

Using the example:
SendMail "john@this.com;mary@that.org"
...

I am using the following code successfully behind a command button:

Private Sub cmdSend_Click()
On Error GoTo Err_cmdSend_Click

SendMessage ("FranklJ@sutterhealth.org")

Exit_cmdSend_Click:...

First of all, I would like to thank Hans for your patience and pieterse for the tutorial.

You guys are awesome and I really appreciate the time you take to share your knowledge (and patience)
...

If a toolbar is docked at the top of the Excel window, like the Standard and Formatting toolbars are by default, its title (caption) isn't displayed, only the buttons. When you undock it (use the...

Make sure that you drop the macro squarely on the toolbar and not beside it (the latter is easy to do if you want to add the button at the end, it has happened to me several times)
This is so...

I created the custom toolbar (Reports)

When I drag a custom button from Commands/Macros to the new toolbar, the title Reports goes away, and the macro IS the toolbar. There is no 'dropdown'. I...

You could try opening the .xlb file and see if that works. If not, you'll probably have to reassign the macros to the toolbar buttons one by one.

Looks like it's going to be 1 by 1. So...

I borrowed a coworker's Personal.xls & Excel11.xlb files. ( I created them for her and now my computer crashed)

The personal.xls works fine. All of the macros are there and function OK.

I...

Thank you Hans - EXACTLY what I was looking for.

Michael

I hope I am describing this accurately:

Column M (April 2009)
Column N (May 2009)
Column O (formula) =SUM(N6-M6)

For June, I copy Column N and insert it to the right of Column N (becoming...

Perfect. Thank you Hans.

Michael

Thank you Hans,

The worksheets are not password protected.

Where can I put the messagebox code?

Thank you,
Michael

I would like to delete all data on a spreadsheet after a certain date.

Pseudo code (On Workbook Open):

If date > (hard coded date) then delete all data on worksheet
And message box (OK only)...

Hi Steve - That one is pretty cool too. I'll give it a shot.

Thank you very much !!

Michael

I couldn't get the right syntax but what you offered worked fine !
=OR(B2="Choice1",B2="Choice2",B2="Choice3")

Thank you Hans !

Michael