I have an enormous piece of code that consists of a bunch of loops (I
know, I know, but it works and its fast enough for me).  The code is
tied to a click event of a button, but its so much code that I had to
move half of it into a module outside of the sheet.  The first half

I have a workbook that someone else created with several worksheets.
When I right click on the navigation keys for the tabs on the left
bottom corner, it displays one shee I do not see when I scroll to the
right and left of the sheet names.  I think the creator of the

I am trying to give a user the ability to comment via email. They click on my
email address and Outlook will appear with my email address on the "To:" line.
Here is the following code that I am using:
Private Sub Label35_DblClick(ByVal Cancel As MSForms.ReturnBoolean)

I am trying to find the row number of a column that matches up with
given values in two cells, right now I accomplish this with a For loop
and check to make sure that it matches up.  I would like to make it be
able to match up based on a list in column two. ie

I have many entries describing sales events, and one of the columns in every
entry is quarter. I'd like to find where one quarter starts and where one
ends without doing any filtering or deleting.
For example, i have

What i want to do is insert data into a range of rows.  But instead of
staticly typing the rows I want them to be determined dynamically
through a counter variable. Heres and example of my code.
Dim counter As Integer

I need to copy data from spreadsheet “ABC” (not its real name) that’s located
on a shared drive, to spreadsheet “XYZ” (also not its real name) located on
my local hard drive.  The range of cells to be copied from ABC will always be
‘Detail Data’!H6:H990.  The destination starting ...

I have used Ron de Bruin's code to send about 50 emails with xls attachments
direct from excel.  
          .Send
to supress the warnings i replaced code above with code below:

First of all I would like to say hi to everyone!  I can't wait to use
this site to help my understanding of excel.  
I run a restaurant and my register dumps data into a computer upstairs
everyday.  I already use excel to manually plug in my sales info, etc

I created (created may be a strong word since they really aren't
original) the two small functions shown below so that in my Excel
macros I could determine how far out in a spreadsheet that data
actually can be found.  Anyway, open up a new workbook and paste this

I Want the code to get a ComboBox or DropDown Menu on the excels
Standard toolbar.
Intention is run all the macros with the help of the  ComboBox or
DropDown on the standard toolbar.

Let say I have 5 tabs labeled AAA, BBB, CCC, DDD and EEE.  In column A
starting in cell A1, I can have the name of 2, 3 or 4 tabs names listed
(number of tabs to select varies).  Is there any way to program a macro to
look at the tab names listed in column A and select just those ...

I have been asked to write a macro in visual basic to truncate a specific
column in excel not to exceed 25 characters.

I have implemented Debra Dalgleish's terrific combo box validation
macro (http://www.contextures.com/xlDataVal11.html), but have run
across a problem.  I want to limit the values accepted from the combo
box to the validation list.

I have a problem that i can not figure out. I need to import new data
file into existing woorksheet but it needs to be imported into first
empty cell in A.
This is the code i am working with right now. It importsw the data