OK, I've read ad nauseam all the posts about finding the last row in a column
with data.  I couldn't find what I need.  I have a slightly different
question that I could use some help with.
Lots of columns.  In the "middle" of each column are 48 rows for a test

I just had my harddrive re-imaged. I'm using Windows XP SP2 with excel
2003.
I copied over my Personal.xls and Excel11.xlb from my backup and they
both seemed to work properly.

Hello,
I'm using ADODB to connect to an ACCESS database I've set up. I have a few
fields that are Date types and I send the SQL statement via a string, the
thing is I'm getting errors when trying to use Variables that are dates in

I have a spreadsheet with a column of names and email addresses.  I have to
replace these with a last name and first initial that can be found on another
worksheet.  The problem is that each cell contains more than one name and/or
email address, and they all have to stay that way ...

is there a cell that returns the numeric d=code for the font or background
color of another cell?
thanks in advance,
mark

Hello -
I have to define the name for a long list of 2-cell ranges. I need a macro
to do the following:
I place the cell in the first cell, then the steps for the macro would be as

I am trying to copy 3 of the 4 sheets in my Excel Workbook to a new
workbook, save the new work book without the macro and close the
original workbook (containing the source sheets) without saving.  I
keep getting the following error message on the copy sheet code, even

I am using the following code to remove duplicate numbers in a column
(deleting the whole row of data), but I am having a problem that the
record being kept is the most recent by date. I would like to keep the
record by date when it was first identified ie the record from January

I started this in another thread, but now it seems unrelated to that
thread.
I've got what seems tb a valid .XLA file (has the little red square in
the upper right hand corner of it's icon, was created by doing a "Save

I have a doubt, i have 25 sheets in the workbook in that i want to find the
data among the sheets, the data which i want to find, that will be in the 26
sheet (A1).
Thanks in advance!

to open a  workbook if it is not already open:
dim path as string
path = " letter:\...\\workbook.xls"
If Workbooks(path).IsOpen = False Then

Would anyone have a VBA code for a macro that changes the color of a cell
according to 5 different rules? If the cell is <=59 the cell becomes blue,
if it’s <=69 it becomes green, if it’s <=79 it becomes yellow, if it’s <=89
it becomes orange and if it’s <=100 it becomes black.

what i have is a list of 25 items.   and those items are on another worksheet
with calculation values associated in the next columns.  I want to be able to
select the item and it insert the associated calculation in another cell on
the worksheet that the list is in.

I have a routine (see below) which I wrote to extract emails addresses
from a large text file (233MB - approximately 7677083 rows).  The
routine is reading each row to determine if three conditions are met.
If the three conditions are met the routine will write the information

I am working on an excel file that has a recordset of medical claims
reviewed.
Columns:
Tax ID