I have this odd problem. One of our users can't run a macro in a Excel XP
spreadsheet. She's getting an Run-time error '1004' Application-defined or
object-defined error. When I log on with my administrative account on the
same Pc the macro runs fine.

somehow I have made the vba unviewable. can someone advise what I need to do
to bring it back. when I go to properties it comes up unviewable. was trying
earlier to mail merge. Don't know what happened
Thanks

Lets say an excel file “A.xls” has been opened and has had some changes made
to it but not saved. Is it possible in VBA to save this file as “B.xls”
including the changes and have file “A.xls” still open in excel so that if
the file were to be closed you could still select to ...

I have 3 worksheets in my workbook.
In First Worksheet named as "Student Info" I am capturing the Student
Name (D9), Student Age (D10)
and in the details section, i am storing the student Mars i.e.

I would like to extract the last names from a group of cells
containing a first and last name and place them into a separate
column. Is there an easier way to accomplish this other than
highlghting the last name and using cut&paste to move into the new

I'm trying to put in formulas for a row of cells.  The row location is
a variable.  The formula is an average of a variable number of rows
above it.  So, there are variables within the formula.  After setting
the formula for the first column, I just want to fill right with that

I am using Office 2003 on Windows XP.
I just want to add a single custom control as the first choice on Excel's
built-in right-click shortcut spreadsheet menu ("Cell").
I want all the functions to work as normal, but I only want it to work in

How do I password protect somebody from accessing the VB in a my
workbook?
Kind Regards
D

hi sorry for being a pain...
I have a worksheet with data from column A to E and from rows 1 to (lets
say) 5000. I want a macro that serches for rows that have "2" in column C and
are NOT BLANK, then select all thses rows from column A to IV (not just A to

I have a worksheet with a number of hyperlinks to cells in that worksheet.  
At any point I can always travel back from link to link using the Back button
on the Web toolbar.
I am assuming that Excel maintains some kind of history list of the links

I need to copy a variable sized range of data from one sheet and paste it
onto the end of a list on another sheet from a VBA routine. I have tried
accessing the variable source range via a dynamic named range setup in the
worksheet itself but my limited skill grinds to a halt ...

When I open an xl file the "web" commandbar always open too. How do I
get get it not to do this?
I tried
"Application.CommandBars("Web").Visible = False"

I have been successful in creating and sending an email through Lotus
Notes.  However, I need to be able to format the body so that the
message is more presentable.  Currently, I filter a spreadsheet based
on two named ranges and send an email to the SOX audit team member

I'm migrating my Excel 2003 VBA add-in to Excel 2007 and am having a little
trouble with Excel's Design Mode:
First, I can't manually get Excel 2007 into design mode.  I go to the
Developer tab and insert a command button onto the active worksheet.  If I

I have  a column for time in my spreadsheet.  The value are as follows:
4:10:18 PM
10:29:30 AM
1:57:33 PM