Hi, I am having a small issue with this piece of code. It seems to run
ok with the sheet unprotected however I need it to run with the sheet
protected.
This appears to be the offending line of code:

Why do I get "Object Required" with this?  What is wrong?  I want to delete
every row that has "Red Prairie..." in the cell.
Sub DeleteRedPrairie ()
Dim lastrow as Long, i As Long

I know there is probably a simple answer to this problem, but fot the life of
me, I can't find it.
Here is my code:
Private Sub SingleValues_Click()

how do I make the sheets in an addin visible...?
thanks
Simon

How can the following range statment: "ActiveCell.Range("A1:A300").Select" be
written for a varialble range based on "Selection.Rows.Count" ?
Thank you
dave

I would like to email a document as an attachment but give the user the
ability to enter in a number that the email will be sent to.  Our MS exchange
users are categorized by numbers.  For example once the user has completed
the form I would like them to be able to press a button ...

Please help! I am using BeforeRightClick to run some code in Excel 2003 VBA
(XP Professional), and setting Cancel=True to disable the default drop down
menu. This works fine when I am working in the .xls worksheet in which the
code resides, but when I try to implement the sheet ...

Whats the best way to go about this:
Suppose i have 15 columns filled with data. Some of the columns contain
data which can be delimited into additional columns.
I have the original 15 columns in a 2D array called myData (-where

I have a simple macro to open  file #1, copy the file, and paste the data
into file #2.  The macro is saved within file #2.  We are on a networked
system.  When I run the macro on my pc, the macro works without
complications.  When a co-worker tries to run the macro, the macro ...

Trying to modify a macro to insert the same header and footer in all
worksheets. In the right header, I'd rather have a month instead and
year instead of all the date info. This is the one I'd like to use if
the date could be modified:

All,
Is there a command line start up switch that will start Excel in minimized
mode?
I found many switches, but not this one.  The reason I would like to use it:

I'm not very experienced with VBE, so used the recorder to write
macro.
As you will see below, it is quite redundant. If fact its too large t
compile.

Anyone,
   I am trying to add and bold a border around a cell in Excel.  I do not
know how to do this in code.  Basically a cell has 4 sides.  In vb .net 2003
I want to select the sides.  Top, Bottom, left, or right, then I want to add

How can I shade every other row of an excel spredsheet.  Some of the rows are
hidden with the auto filter on.  My results always end up with the even rows
gray and the odd rows clear.  With the autofilter on, some times the odd rows
are adjacent, and sometimes the even rows are ...

Excel Helpers
I am building a userform and would like to display the company logo on the
first page.
If I embed the image into worksheet 1 (i.e. EMBED ("forms.Image1")) how can