I am trying to create a macro that will find the word "DATE" in column A,
then copy the date in the cell adjacent to it in the same row to cell D2.  
Can someone help me with this, I've looked for roughly 2 hours on how to
accomplish and haven't gained any ground....Thanks for ...

I'm trying to create a small plugin for Excel that will take a column (the
current selected column) and split the text into seperate columns based on
spaces.
I have the code to select the current column (although it is taking the

I use the code below, kindly written and provided by Ron de Bruin,
which E-Mails a sheet called "e-Trip", how would I tweak this to e-
mail all sheets in my original workbook except for 2 specified sheets
which I don't want to mail. Reason for this is my workbook contains an

I Need the code that can generate sheets with date of all the working
days in a month.
Note - Working days are the days between monday and friday.
Thanks

This may be an easy one for a VBA guru.
I have to update a production schedule daily by sales order number.  I need
to copy and insert non-duplicated rows from Worksheet 2 into Worksheet 1
according to a specific column.  For example,

I have an Excel form that I am using for data entry.  On the form, I have
several command buttons that I want to assign hotkeys to, but the standard of
setting the caption with an ampersand before the character does not seem to
work.  The caption displays the ampersand rather ...

just wanted to ask if it is possible to change the default setting of the
autofilter->customized filter from "equals" to "contains" by default for all
past and future worksheets
tried a bit with recording macros and stuff but dind't really find a solution

In one cell, I have: =if(randbetween(1,10)<5,randbetween(1,10),0)
But I soon recognized is that the 1st randbetween not necessarily same
as the 2nd one?!
How can I make sure that both randbetween values are identical?

Hi. I'm new to this VBA thing as a co-worker recently left and I was bestowed
his workload. Joy to the World! Oh well it is a chance to learn....
I need to take data from  Cells B8 & C8, and copy them into J8 & K8 upon the
user hiting the enter button.

I've a workbook which I want to protect. I protected the sheet etc
already. But it is still possible to run macro's manually trough the
menu bar.Tool>Macro>macros
Can this be turned of when opening the workbook?

thanks to JGWhiz, Joel and Michael for their suggestions.  I just wanted to
let everyone know what the problem was.  It kept stopping on the RowsPerPage
line with an out of bounds subscript runtime error.  Out of desperation I
changed the line changing the view from normal view ...

1. I am trying to capture the Exit or LostFocus event of a combobox on a
UserForm.
The Forms controls don't have a handle in vba and, while trying to find the
window 's class using Spy+, it seems like the combobox doesn't have a window

We have a spreadsheet used by our vendors; we put certain data in it,
then the vendors put other data in it. The data we put in it changes
frequently and we'd like to be able have the workbooks update
dynamically whenever any vendor uses one, rather than send new

I am scanning a customers PDF 417 bar codes into excel. The information in
the bar code is separated by equal signs. Is there a way to have excel treat
these equal signs as tabs?

Hello Ron from Steved
Ron what is required please to change the sheet to Value Only. Thankyou.
Sub MailToDepots()
'Working in 97-2007