I have a workbook with two worksheets, namely Archive and Data.
The following code clears all the cell in the Archive worsheet when a click event is
started.
As all cells are cleared, it wipes out any formulae as well!

I want to hide the entire row, if the value in column b is Yes.
So, I tried this:
Private Sub CAT()
   For b = 1 To 25

Hi
No idea on how to do this.
Need to open a recordset from an SQL Server.
Basic details: server name Demo

I found out how to enumerate all machines on a domain:
   Dim sDomainName As String
   Dim oDomain As Variant
   Dim oComputer As Variant

I have 1315 rows in Excel.  They are B2 through B1315
I have a DIFFERENT weblink in each row and I need to make them all a
hyperlink.  I don't want to have to do this one by one.  Does anybody
know a way to do them all at the same time?  Please simplify

I have workbook with approximately 50 Name Ranges that I have defined for my
Macros to Access. My macros used to work perfectly.
Yesterday when I activate the Macro, the macro gave me edebug messages. In
Excel, when I was verifiying the Name Ranges, about 20 of them defaulted to

Here is my code.  The problem is with the saveas command.  It doesnt work.
When i click the button i want it to ask where to save as, with the initial
file name to be "proj".  Any ideas?
Private Sub CommandButton1_Click()

I have a various number of rows generated in a worksheet.
So There is a various number of pagebreak in this sheet.
[I notice that the text in the last cell, of the last row just befre a
pagebreak is wrap to the first cell of the first row just after the

Using VBA in open Excel workbook I want to determine if a specific workbook
is already open. The complication is that multiple Excel processes may
already be open. What's the easiest way to do this?
I suppose what I'm really looking for is some way to iterate through all the

I want to validate all of the cells in Column G with a list of unique items
already in Column G.  This can be triggered with the Sheet_Change event.    
What is the best way to do this?

I have a report template that saves a report twice; a 'DatedReport 20070227'
and a 'LastReport'.  I created a 'LastDate' table in the LastReport report
that is refered to in the template (it is in a small data query).  So when
the template runs it updates the datatable linked to ...

Does anyone know how to use wildcards with Conditional Formating?
I need to highlight all ROWS in a spreadsheet CONTAINING the word
"Total".
Normaly I would use conditional formating with the following

I am trying to autofilter the AI column and then cut the results and
send them to another file. Does anyone have any idea how to do this?
Thanks for your help,
Peter

I'm trying to call a function in the after update sub, and pass it the
name of the combobox, which has been updated. I'm just not sure how to
access this.  Can anyone help?
Thanks

I asked this question in a roundabout way last week with no success.
Basically, is it possible to compare text of one cell to another cell
to produce a % of correctness.  It doesn't have to be exact as I am
only using it to set up a French revision spreadsheet.