I have a routine which I have used frequently (and obtained from this
group) to send mail from Excel to Lotus Notes.  This works extremely
well and is shown below:
Sub send2()

I have data that goes
Name,Project,Period,Count
A1, B1, 5,10
A1, B1, 6,20

Hi! I have a problem with a loop. I want to search the entire worksheet for a
cell that contains the text "Sec type". However there is one cell that
contains "Sec type" that I do not want to search, ie if that cell is the only
one found containing "Sec type" then the search will ...

My worksheet contains data such as Name, Address, Tel, Age etc.
I would like to run a macro that would sort and print all the relevant rows
by Col I being Age
I would then have a printed page of all the names address etc who are aged

i wish to copy data from all worksheets to one worksheet if they meet certain
criteria. basically i want data that is highlighted to be copied to the new
worksheet.(i do not need the whole row data, just need data in col a to l to
be copied). In addition to the data copied, i ...

I new to VBA programming.... so sorry about my ignorence...
I've made the following code which draws a time diagram, each step
containing three lines. Manual labor, machine time and movement. So far
it's working well, Step 1 starts in H11 and depending on the values in

I want to change the date format in VBA from "13.07.2006" to "20060713".
If I try to record a macro applying the Format, Format cells... function,
nothing happends.
The excel workbook has date values in column A with the wrong format

I have a workbook with 20 named sheets.
How can I programmatically arrange them in alphabetical order?
--
donwb

i copied this section of code from
http://www.cpearson.com/excel/deleting.htm
as listed in another post, and am trying to use in in the middle of
another macro.......

I have a question about a specific macro that I am trying to create.  In
this macro I want to have it so when a user enters in their first and last
name in the two text boxes on my user form and click the command button
titled login it will then take them to a specific range of ...

Is there a way to turn off the "Do you want to save this file" message if
you have not done any work on the sheet?

In Excel .5 is always rounded up when the decimal places are reduced,
ie. 3.55 becomes 3.6, 3.65 becomes 3.7 etc. I need a formula that will
"throw .5 to the odd" so that 3.55 would become 3.5, 3.65 would become
3.7 etc.

Is it possible to use other logical operands such as Greater_Or_Equal in a
Selection.Find statement? If not, is there another way to find the first
Greater_Or_Equal cell in a sorted range?
My search range is currently 12000 cells and growing so I prefer not to

I was wondering is it possible via macros to load a userform & deselect
it so that users can scroll in worksheet immedietely. Currently after
loading the userform I have click the worksheet before I can scroll
with arrow keys.

Hi, I am trying to use Excel VBA to block SAP vendor master MK05 by toggle-on
"selected Purchasing organization' checkbox. However, there are some vendor
had already been blocked previously and should skip checkbox activatation.
How do make use of VBA to check if the checkbox is ...