I am including the entire macro, but it is the last 3 lines that I am
concerned about.  Basically, by the time the macro gets to that point, 2
workbooks are open.  I am running the macro from the User workbook.  But I
want to go to the module in the Dev workbook and use the ...

Hi all, i got the code below and need some help to modify it to meet my
new requirements.
This code works great, i just need it to count if the range "AQ" is
either blank or "N", but cannot seem to get it right ??

I am launching an external application from excel and need to obtain
control of excel after the external program launches. This is all done
via VBA. VBA wants to wait for the installation to finish before
giving me excel back. I need to overcome this and have immediate

I have a workbook with formulas that only work in Excel '07 (using the
iferror function).  When the workbook is opened, I want to check if the user
opened it with an earlier version of Excel.  If they did, I want to tell them
to open it with Excel '07 and then automatically close ...

How can I sort only the UsedRange of each Worksheet in a workbook?  This is
what I have so far and it will not let me.
Sub Sort ()
   For Each wks In Worksheets

I just got hit with a hot request and am looking for commands/script
that will search the text in a cell, find the last occurance of a
repeating character and then delete the rest of the data in the cell
from that point to the end.

I have data that is pasted into column "A" from a macro. The macro first
deletes all data from the sheet ("Totals"), then runs a db query on another
sheet ("Receives"), subtotals, then copies the subtotals back to the original
sheet ("Totals").  that rage will always be dynamic ...

The subject seems to be easy, but I'm not finding any helpful code
that provides insight to doing this. Can anyone help me out on this
one?

Excel 2003, sp2
Hi,
I have several named ranges in a worksheet. The user is supposed to enter
values into some of them to be used in various formulas. The cells are

Having problems with another macro, i dont understand how they randomly just
trip up. The below code is working absolutely fine and changes the desired
text to how i want it to, but for "Applabs" it changes everything in the
corresponding cell to Sub contractor (as it should) ...

Perhaps someone can help me determine what I'm missing here. This little
bit of VBA code works on machines that have VB6 installed on them. When
I take the spreadsheet to another machine is when it fails.
When I debug and mouse over rdoEngine.rdoEnvironments(0)...it says Object

I seem to have done a poor job explaining what I am trying to do.  In order
to be more clear I am submitting most of my entire macro.  
First I loop
through the cell range a:17 to av:56 and copy all rows with the criteria in

I am given the task of expanding an already existing macro, however
I'm a bit novice I suppose and I am stuck with the program not working
with the added changes, so I'm doing it wrong. I have simplified the
code and functionality to better enable me to explain my problem and

I have 2 rows of information. 1) volume (1,000,000) 2) unit of measure
(lb). I would like to have it where on the data value on the chart it
would say 1,000,000lbs combined together. I have label code where this
works. I also would  like it where if I change cell value D5 (where

I have a worksheet that has 3 tabs in it.  Tab1 has updated data in it,
tab2 has deletions in it, tab3 has the original data in it.
Each row in each workbook has 10-12 columns of name & address info
associated with it, each line (Col A) has a unique record number that is