Code:
--------------------
   Public Sub HotTPassword()
 Dim irow As Long

It got the following code
Code:
--------------------
   Sub viewtables()

I have a column which contains text which has either "Completed" or "Not
Started".  I sort by that column, then want to find the first cell
containing "Not Started"
Do While ActiveCell.Text <> "'Completed"

Hi all,
I've created a Sub to send an email from excel as shown;
Code:
--------------------

What is a good formula for Deleting a specific range of rows?  I am trying to
figure out a way to delete all but the last 10 rows from a large set.   I'm
implementing it into a macro, and am struggling with how to get it done.  I
currently am experimenting with this:  

I recorded this macro so that i could use the code.   I was wondering if
there is a more efficient way of writing this code?
Sub Macro1()
    With ActiveSheet.QueryTables.Add(Connection:=Array( _

Excel 2002, SP3
Here's an issue that I have noticed.  When I use VB's Command Button (Visual
Basic Toolbar button, click on Control Toolbox, then click on the command
button within that control bar), each time I go into Print Preview, then

We currently have approx. 700 schedules in our scheduling software and
we often need to export them to count how many Mon - Fri, Tue - Sat,
Sun - Thr shifts.  Being a 24x7 operation, the combination of days
worked vary alot.  Ex.  Mon, Tue, Fri, Sat, Sun.  The format of our

I'm on a roll now...
How do I get cells to populate with the following on save?
Date
Time

I'm trying to automate the creation of pdf files.  I posted my code
below.  The line I'm having problems with is
pdfDist.FileToPDF "c:\My Documents\testExcelToPDF.PS", "c:\My
Documents\testExcelToPDF.pdf", ""

I am trying to make a shortcut, but the bit iam missing is quite an
important technical bit that will help me elsewhere.
basically, the shortcut puts a countif formula next to the active cell when
the macro is run e.g. in B2 next to the data in A2. i want it to countif for

I have a macro in Excel that works just fine when I run it from the toolbar.
However, when I create a CommandButton on the spreadsheet itself and copy the
code from the macro, it will not run as hit encounters an error and goes into
debugging.  Can anyone shed any light on this as ...

Dear all,
I want to create a function (maybe just a common IW question in fact) to sum
up a column, which have a dynamic number of rows!
My user will retrieve data from DB and display in a column, but the number

Does anyone have any code available which lists all the macros in a
workbook?
Is there a way of drilling down through the VBE to get to macro names?
I can list the names of VBEComponents but cannot seem to find any reference

Hi.  I defined a macro that will copy the current row and do a copy
insert.  It looks like this:
Sub CopyInsert()
   ActiveCell.EntireRow.Select