I need to have this code delete records of parts from a worksheet that do not
match a parts list (in sheet "Elgin Parts"). However, I get the error
"invalid or unqualified reference" when I run this code. Why is the code
".Rows(I).Delete" a problem? Any answers? Thanks, GD

I am importing data from another workbook and I would like to know if
what I am doing is possible.  First I open the workbook, then I run
this code:
Set wbBookdata = Workbooks.Open(fPath & datafile, False, True)

I am trying to sort through a file and select only the 25th line of a
secondary worksheet titled "raw data". The basic formula I was using is
below:
=SUM((E4:E23)*(MOD(ROW(E4:E23)-ROW(E4);5)=0))

Hi MVPs
I have 2 date cells formatted as dd mmm yyyy hh:mm:ss in Excel 2003
one is budget date in D3 and the other revise budget date in D4.
I have a macro that reads:

Is there a way to make a cell have a character counter? The cell is validated
to only allow 30 characters. I need to put in a counter that as the person
types, it shows they are on character "13/50" and keeps counting as they type.

I'm trying to put together some VBA where it will search a specified
column (column AE) for values.  blank cells will be ignored, cells with
a value will be cut and pasted to a new location (column AF).
can someone give me some suggestion with the code?

I'm using absolute references to allow a set of formulas to be copied across
and down a spreadsheet with only certain values changing relatively. After
the formulas are in place, I need all absolute references to be returned to
relative references so the sheet will still function ...

is there a way to initiate code if a row has been inserted into the
worksheet, and to tell where the row(s) were inserted?
ex: if the user just inserted a new row... do this... (msgbox (you just
inserted row(s)...)

I'm not sure if this is the right place to post this, but here goes...
I've built a macro to format an Excel sheet of data to mirror the
layout of an Access table.  I'm trying to figure out a way to automate
the merging/appending of the Excel data into my Access table, either

Hi, I'd like to make an input box pop up with a default value on it,
that should be stored in a variable, and that any information on this
would then be inserted on a cell like an excel formula.
Questions are:

I am trying to populate a Combobox list based on the choice of the previous
combobox.  I can store the choices in a table in the proper array format.
Example "CS8", "CS8M"  in the cell.  But it will not let me assign that to
an array field.  Is this possible.  Now matter how I try ...

I have a live data feed into an excel spread sheet and want to be able to
change the color of the font when value of cells change either positive or
negative. E.x., red when it goes down and is negative and green when value
goes up? And suggestions would help greatly

I need to use some old application (written in FORTRAN, but I haven't
got a source code of this application) in macro in Excel. I want to
communicate with this command line application, send some keys and
receive result. I have tried the SendKeys function but it doesn't

I have a spreadsheet with a variety of formulas on it that I now need
to round to thousands.  I tried to build a macro that edits the
selected cell and inserts the Round function around the existing
formulas as follows

I'm new at this so please bear with me.  I'm trying to run a non-microsoft
application using the vb in excel 2003.  I can do it using the sendkeys
method but I need a better way.  I can't get DDEInitiate to work with the
other application.  Can anyone help?