In Excel, we can group data in a field, for example:
We can group A1, A2, A2 as  List_of_1.
Is there a way to do this via VBA? I have a lot data points to group
and I want to automate the process.

Is there any VBA coding that will allow me to e-mail a file from within
that file?
I want to be able to put a button in an excel file that will let me
e-mail the file it is in to a list of pre-assigned e-mail addresses.

Excel XP & Win XP
Ron
   I was perusing your email code in:
www.rondebruin.nl/mail/folder1/mail2.htm

I'm wanting very much to make a large times table.
But, when I click-drag the corner of the cell over, it will repeat the
formula that multiplies the same cells over and over again, not the
next one in sequence.

Excel XP & Win XP
I know how to open an Excel Workbook file.
What I want to do is open a non-Excel file when I know the full file name:
"C:\ThePath\FileName.xxx"

Noticed on the Controls Toolbox (for the first time) a button labeled
"More Controls".  When I click on this, it shows me a list of 200+
other controls - one of which is Microsoft Treeview Control.
I selected this and put it on my worksheet.  But looking at its

Can someone help me with a Macro to create multiple workbooks from a
single Excel spreadsheet?The data on the spreadsheet is similar to the
following:
A              B                  C

When I use a Vlookup function in VBA to search the record entry dates from a
range, it cannot find the record and just returns the run-time error.   I am
sure that the particular dates exist in the range since I have used Countif
in VBA and Vlookup in worksheet to test if it ...

I've built the following function to create graphs (based on other
functions I've seen online):
Public Function AddChartObject(objWs As Worksheet, intLeft As Integer, _
        intTop As Integer, intWidth As Integer, intHeight As Integer, _

Hi
Got the code from this forum (By Ron) how can i define a action after the
Application.SendKeys ("%{DOWN}") procedure
i mean i want when the value is selected from the DV list by the user, then

I have a sheet in which i have several columns. for example, column A
contains "publisher name", column B contains "software name" and column
C contains "version"
i would like to scan all records of this sheet and store result in some

is it possible to use a private sub to change the name of a worksheet
as soon as a specific cell is changed (cell value must be part of the
sheet name)
thanks in advance

~~~~~~~~~~~~~~~~~~~~~~~~~
Private Sub Worksheet_SelectionChange(ByVal target As Range)
Const WS_RANGE1 As String =
"C11,C15,F11,F15,I11,I15,L11,L15,O11,O15,R11,R15,U11,U15"

I have a value in cell A1. The format of cell is General.
Now using a function I am checking if the value is >= 0.35 like
below...
sub test()

I have a value in cell A1. The format of cell is General.
Now using a function I am checking if the value is >= 0.35 like
below...
sub test()