Using Code to find a value, and if found, then delete the line.
Simple right?
   Cells.Find(what:="2000103", After:=ActiveCell, LookIn:=xlFormulas, _
       LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _

Please see code:-
Sub Sponsoracsselection()
'
' Sponsoracsselection Macro

I would like to gray out worksheet tabs on opening an application, and
enabling the tab via a macro. Is this possible ?

I am using a macro to place a timestamp on workbook open  and it saves it at
this time but if i rename the work book, then try to run the macro i receive
a file not found.
Private Sub Workbook_Open()

Public Sub Workbook_Open()
Dim wkb As Workbook
    Dim wks As Worksheet
   Set wkb = ActiveWorkbook

I've been fustratingly looking for NON-DRAG down methods of adding
totals from the leftward column into a right column and HAVE the
inserted lines CORRECT the running accumulative total without the silly
pull down / drag down process over and over again including what

I have validation procedure in a selectionchange event that when activated
causes a Comboboxchange event which in turn causes a Selectionchange event
and I get the subject error ,  when the validation procedure runs again. What
I want to do is resume the selection change event ...

How do I loop through folders and get the first file from each folder?
I have code that will loop through a set of folders, gets the column labels out of the first file in each folder and lists them in
the current workbook.  The problem is that I'm getting the first file in each ...

Hi people!
I would like to jump out of a Do loop using the goto statement e.g.
Do Until  condition
      While i>= 0 And i < value

Hi;
Somehow Personal.Xls started adding a workbook and a worksheet when I open
Excel.  I want to keep the personal.xls modules but I want to stop the
workbook & sheet from opening up.  How do I do that?

I have some columns in my workbook that are frozen so they are always
on the screen. This leaves a very ugly bliack line up and down the
sheet. Is there any way to get rid of this?
Thanks

 i'm trying to modify the following code from Ron de Bruns Excel page.
i need the macro to delete all rows that do not equal "abc" in column
C; instead of deleting all rows with "abc" as it currently does.   how
do i modify this?  If i use "<>" by Criteria1 i get an error.  also,

I need to create a macro that can be used to increment/decrement the
numeric contents of a cell based on repeatedly pressing the up or down
arrows.  Each key press would modify the cell by a standard increment.
Up arrow would increase it and Down arrow woud decrease it.

I get a Run time error - application or object-defined error if I run
the followign code with an active sheet other than the one the range is
on (NumRowPN = 7 atm):
ThisWorkbook.Names("RunTime6").RefersToRange.Range("A1").Range(Cells(2,

I'm badly in need of some help with an excel formula. Essentially I
need to check to see if the value of C7 is "Y" and if so for the
formula then to look at D7 through to J7 and look for a value of "Yes".
the total amount of "Yes" boxes should then be multiplied by J5 and the