I want to delete work total if found in the sheet.
The problem with below is that it is only deleting case sensitive
values.
ElseIf c.Value Like "*TOTAL*" Then ' Case sensitive

I have a Listbox on my userform which has referances 14 columns on a
worksheet. What I need to know is how when I click on the Finish button on
the UserForm, can I get all the data from those columns to fill in the
current worksheet, starting with the current cell?

I have a wordart ("WordArt 36") that is referenced in a macro.  
When I copy the worksheet to another worksheet, the name of this changes to
"WordArt 32"
Is there a way to copy the worksheet so that the name of the images stay the

I can not get the examples provided in the SDK to work under Excel
2000, they do work under Excel 2007.
Does anyone know what I need to do to get it to work in Excel 2000?
Thanks,

I have used subtotal on my data and have copied and paste special'd my data
to another sheet, I know want to delete all the rows that dont have the word
"*Total*" in them.  I am fairly new to vba and would appreciate any help
anyone can give me.

I have the following macro to import a text file (fixed width).
Sub Macro1()
'
' Macro1 Macro

I picked up some code that allows me to select an item from a drop
down and it displays a corresponding value.  But it replaces the drop
down selection - what I want it to do is display the drop down
selection in the current cell and place the corresponding value in the

i am using the "activecell.formula" function
when i assign it to a variable i see the "=" sign
how do i erase the = sign?
Thank you

in one complex Excel 2003 application some formulas stopped to show their
results.
Moreover, if I cancel the formula and rewrite it, (e.g. =SUM(C10:AG10))
the formula remains written instead of disappearing and formatted like if

In need to be able to highlight a row if the date in that row is greater than
10 business days. I have already stored today as a variable called "today."

I used Debra Dalgleish's website to Make the Dropdown List Temporarily Wider
(http://www.contextures.com/xlDataVal08.html) and I put the following code in
my sheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

What is the best way to count the number of times a variable is in a range of
cells?
Thanks

I am trying to copy and paste the last four tests from a sheet ... here is
what I have so far:
A list box with no dupes lists mix types on sheet("test database").  I pick
the mix type (there could be as many as 25 different mix types spread over

that case,,, the line have 50,000 data..
i want to select the all data...
but, lbx.selected(i)=true....... is no good... this is slow... for
loop..

I have some code that enables and disables cut and paste. The code is turned
on with the Workbook Open event and turned off with the Workbook Close event.
Some users though are having this code linger and not turn off... any things
that can happen that would allow the user to ...