I have data in a few rows and columns, I would like to copy those rows and
columns (approximately 6 total) and paste this information into a comment.  
Is this possible?

There is NO problem with the Code 1, it works great.
Code 2 does work, but the user needs to Re-Enter the cell for the msgbox to
appear.
I need it to work if the user leaves the cell, and a value is found that

I'm trying to create an add-in to distribute to several users. The
add-in is used to apply user-defined chart-settings to excisting
charts. I know how to create the code to apply the settings, to save
it as an add-in and to load from tools -> add-ins...

I have a field that contains date and time, I would like to use the LEFT
function to trim off the data I do not want, as the output is to be used in a
pivot table (yikes). I am hooked to a FOXPRO database. Any suggestions?
Many thanks!

I created several macros to change the "scale" in my charts. It changes the
scale fine but occasionally it finishes by moving to a new location? This is
obviously very frustrating, any ideas why its doing this and how I can fix it?
James A

has anyone ever found a way to put gedcom files (ancestry files) into excel
and fill the columns in the order they want to, ie put a formulae into a cell
that reads the gedcom file direct? This will then allow lists to be made
direct from the gedcom file.

I would like to know if it is possible to make controls in VBA form look
like XP controls ?
thanks a lot,
Al.

mycat is a string in my I column or column 9 (defined as MyCategoryCol)
Export_Info(mycat as string)
{
...misc variables.

Greetings!  Is there a way to create a list of the objects, such as buttons,
defined in a workbook?
Thanks,
George

I try to improve my VBA macros in the following fields :
- execution speed
- reduce the CPU usage
- reduce the memory usage

I have a number of matlab scripts but have lost access to the program. Is
there anyway to convert them to an excel add-in or VB application without
rewriting the scripts in VB?

I have a function that creates a 2-D array within VBA and stores this
as part of an object's data.
With another function I would like to access just a specific "column"
of that array.  if the array was stored in an excel sheet then I could

I have a spreadsheet with many rows.  I want to sum a column based on the
contents of another column.   No problem.  With this formula, I can do that:
=SUMIF(Results,"2-In progress",TCV)   where Results and TCV are named
ranges.

A few years back, I built a large XL97 spreadsheet which includes a
macro called "CreateMenu" that inserts a custom pull-down item in the
menu bar.  The macro runs and creates the menu items when the file is
opened, and runs again when the file is closed.  I've used this macro on ...

A few years back, I built a large XL97 spreadsheet which includes a
macro called "CreateMenu" that inserts a custom pull-down item in the
menu bar.  The macro runs and creates the menu items when the file is
opened, and runs again when the file is closed.  I've used this macro on ...