Last month I posted regarding an issue I had encountered with <a
href="http://groups.google.com/group/
microsoft.public.excel.programming/browse_thread/thread/
299627eb5d36ff66/12ae5022656f1dfb?

Hi all.  I have a worksheet with 30k plus rows.  I ran a vlookup in
column AA.  If the value in column AA=1, I would like to delete that
row.  I found some code on this group to do that (below) but it ran
for 20 minutes, and I eventually killed it.  Any ideas on how to

Hi, I work in a development organization and we take our products through
various "stages"... here are the variables:
1) We start at Stage 1 and Stage 5 means 'ready to ship'
2) We have 3 different product classifications, A, B, C

I have data in sheet 1 (please see below)
A   B   C        D    E       F ---------Columns
2        50                   200801
2        50                   200806

Probably the wrong group but I'm hoping someone will help anyways:-)
When our users open 2 workbooks by double ckicking the files from
their drive - as opposed to file/open - both workbooks are in 1
window. They can compare side by side and choose the vook from the

I've been working on the following code, but get an error on the
designated line - can someone help?
 Dim rCell As Range
    Sheets("Form").Select

We've been using this since August 2007. This just started happening
about two weeks ago:
In Excel 2000, the application freezes when the user types in the
combobox to select an entry. The worksheet starts calculating and

I am trying to delete columns 'A' and 'B' based on if there is some data in
column 'C'.  I am trying to write a macro to accomplish this. Any help is
appreciated.

I am having a command button in excel worksheet.
When I click the button, a word document from c:\krishna\fff.doc should open.
Can anyone help me to achieve this task.
Krishnakanth

200702      146188         C33                      C33
200703      146306         D55                      S45
200704      146392         S45
200705      146504         TT5

Thanks in advance for your help.  I have looked into many threads and other
websites but I now really confused. I am a moderate user of excel as most of
my time is spent in Access.
I want to look at every cell in column A and want to return a value for the

Our Excel VBA Add-In hits our server one or more times every time the user
hits F9 to recalculate their values. Sometimes, the users who have written
the spreadsheets have organised things in such a way that the function is
called 5 or more times which results in 5 or more calls ...

When using a ComboBox in a Userform, I'd like to have the RowSource linked
to a column on a sheet.  However, in the event there are duplicate values in
this column, I would like the ComboBox dropdown to only show each value one
time just as the AutoFilter does.  Is the ComboBox ...

One column in a personnel roster spreadsheet contains the number of years
each person has worked for the company. Is there a way to make this number
for each person self-increment (ideally on each person's hire date
anniversary) so the spreadsheet will remain accurate, year after ...

I'm trying to copy a range from the issue worksheet which is in the open
workbook to the Issue workbook.  The sheet name is from a dynamic formula on
the lookuplists sheet which is open but hidden.
It fails on the set Destrange line.