Ok The SUM for each row is easy, How do I get each row to drop the lowest
value for the SUM,

A manager told me he read in a trade journal that VBA will no longer be
support by MSFT after year end.  Is this true? Or, did he misunderstand an
article?
Any clarification would be greatly appreciated!

Hello --
I need to create a custom function that I will use in a formula, and it
needs to take action based on the contents of another cell on another
worksheet in the same workbook. The idea is to get a different from the

hi,
I have the following:
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select

I am trying to find out how to build a macro that will assign numbers
sequentially to a cell once the user has input specific data such as
assigning authorization numbers to certain documents.

I want to filter some data by, among other things, whether the date in one of
the columns is between the date the macro runs and Saturday of that week. The
macro will not always be run on the same day of the week. I searched high and
low on this board, but found nothing like that ...

This gets me the file name but need the path seperate
Path = Left(ActiveWorkbook.FullName, Len(ActiveWorkbook.FullName) - _
   InStrRev(ActiveWorkbook.FullName, Application.PathSeparator))

I am trying to pull information that is summarized in a pivot table and
return it in a report. The returned info will be dependent on the leftmost
column of the report and the month that the report is being pulled for. The
pivot table has each of these pieces. For example

I have string like that :
NESN 380.7 STR 01/28/2008
and I want to be able to grab the value between the first two spaces;
380.7. I know how to find the first space but I don't know how to find

With this code in a macro for Excel XP in VBA, I open an 'output' document
and then it in turn opens a source document so that the cells can update.  I
want to hide the source document when it opens, but leave all other Excel
files, especially the one I just opened, unhidden.  ...

How do I do VB to read a row then act on the relevant columns.
Say in row 6 I have 3 different variants, A B & C. If user pushes button A I
only want all the columns with A in row 3 displayed.
How do I do this?

Hello;
I have a data stream that I am reading from a .txt file.
I am trying to write code that will allow me to find an exact match in
several files.

RangeObject.Delete method will delete the existing range and shift the
remaining contents upward or leftward. I would like to find some means of
clear the content of the range and move the contents (not formats) upward or
leftward. Any ideas? Thanks a lot.

I need a macro that sort of performs a lookup, based on first, the
letter I would input in col. E, and then second, the column that the
curser is in, (which could be any or all cols. from F - P) and then,
when i invoke it,  displays a corresponding sheet that will contain a

I am attempting my first attempt to connect to an Access database using ADO.
When I try to open the connection I get a run-time error -2147467259
(80004005) Could not find installable ISAM.
what the heck does this mean?