Column "D" has random date values in cells
I need to retrieve the min and max dates from this column and store values
in a varible.
I have tried the following:

I am assigning a two character string to a variable as follows (Stringy is
the variable I read each record form before breaking it into pieces):
ThisActy = Mid(Stringy, 4, 4)
The record I am reading from has "00  " (two zeros and two blanks) starting

In Office 2003, I typically created self-installing toolbars in hidden
workbooks which I then emailed to users. When users opened the program file,
the toolbar would be built, but the file would run hidden. At any future time
that the user needed those programs, they would just ...

Hi all
i am wondering if there is any way to be able to get a date into the cell
automatically but it stay as it is without being updated after closing and
reopening the file. what i mean is that i want to put some data in one cell

Hi, I want send work book thruough macro in ms excel.
I have oultlook configured in my system , I am using excel 2007.
Please help with vba code.
Thanks in advance.

Have created and filled a combobox using .ControlFormat.AddItem
.ControlFormat.Value seems to return just the index number of the
selected item - how can the actual value from the combobox be picked
up? Thanks.

I have a problem with Microsoft.Office.Interop.Excel.Range.Group()
method.
The problem is that I can call this method only 7 times, before it
throws me an exception.

I am a newby to excel
I have a work book with three pages: spending tracker, category, and
spend_catogory
there are ten items listed on the category page with range ( A5:A14) this is

I would like to ask help from anyone in the group regarding the this
error everytime I run my macro. It used to run before but all of a
sudden, i don't know what went wrong, but it won't.
Macro code:

Here's the spreadsheet I'm working on:
http://www.myfootsmells.com/excel/copypaste.xls
I want to copy from A2:C4 and then put my cursor in C9 do a paste and
it'll fill in the hours accordingly.  Possible?  It doesn't need to be

Private Sub Workbook_AddinInstall()
On Error Resume Next
Application.CommandBars("Worksheet Menu Bar").Controls("WB Example").Delete
Set cControl = Application.CommandBars("Worksheet Menu Bar").Controls.Add

Variable declared, set, so why is range failing?
Sub CopyCoVR2CtySht()
Dim wbSource As Workbook
Dim wsCoVR As Worksheet

I'm in the process of creating an excel spreadsheet that interacts
with Outlook via VBA.
A user is complaining of an error on the following line in VBA
qcount = Application.WorksheetFunction.CountIf(qrange, qLookfor)

I have the following code for a userform:
Private Sub UserForm_Initialize()
Dim item As String
Dim num As Integer

As shown below, I measured the gross flow of five wells (P, Q, R, S, T) with
the aid of three different measuring instruments (A, B & C). How can I use
excel to  accurately predict A4, & A5 (The missing gross flow when I used
instrument A)?