The below code removes hyperlinks
Sub ZapHyperlinks()
  Cells.Hyperlinks.Delete
End Sub

I'd like to write a macro that goes to each sheet in turn, selects all
cells and paste special values. I've got his far but it only seems to
work for the active sheet:
Sub removelinks()

I'm have a named range in Worksheet1 which is used back on Worksheet2 (as a
list which from which the user can choose).
Depending on what the user selects I want to perform some calculation, but
that's where my problem starts. For example

I am trying to create a list of all values in a row on several spreadsheets.
For example i have 6 worksheets, monday, tuesday, wednesday, thursday,
friday and summary.  I would like to create a continuous list in the summary
of all claim numbers from monday to friday without any ...

Dear Excel Gurus,
I need help.
I have written an Excel Application that processes data (extracts
information from other excel workbooks) and writes to a csv fie). This

I am trying to copy a range of cells from sheet 1 to sheet 2 every second,
but incrementing the sheet 2 column every loop to create a history trail. The
code is working but at run time it pastes only the first copy of the loop for
every iteration. So all the pasted columns are ...

I'm trying to display message box that combines text along with a
variable that was previously defined.    The following code only
displays the date that's contained in the variable Dt,  but it doesn't
display the text.    How can this be done?

I have a data sheet in which I have written a macro to add up columns upto
row #503. However every month I do not need 503 rows, sometimes its as small
as 20, or sometimes I need all the 503 rows. I was wondering if anyone could
help me figure out as to how to delete rows if more ...

I am using a macro to drop completed workbooks, or parts of completed
workbooks into an email, using   Application.Dialogs(xlDialogSendMail).Show.
As the various mails are sent to specific groups or department mail box's I
would like to have the To: and CC: fields completed ...

If I protect my vba code the workbook_Open functions do not work.  Neither
does Before_Close() functions.  Any ideas?

Hi all, i am using the script below to check for and install a desktop
shortcut. However it does not see that there is a shortcut already, but
installs it ok. I do not know if i must have a certain "referance" flagged or
not. Any help would be appreciated...

If I add a worksheet as in the code below, can I force the name of the new
sheet to something because this code was working fine on my PC, but on
another user's pc, the added sheet was Sheet4.  Instead of changing their
template or whatever might be causing this, can I just force ...

I made a post to the functions DG earlier in the week, thinking that the
issue was related to a function, but I did not get a solution there, and I am
not really sure it is a function-related question…I guess it is more of a
programming-related question.

I have many pictures that I want to extract the data from and put into an
excel spreadsheet.  I can use the Microsoft office document imaging, but this
takes too long.  I want to have a macro that will take the picture from
Excel, put it into the document imaging, run the OCR and ...

I am producing office 2007 files (with no macros) directly on a webserver
from .net. I was then going to rely on users having the compatibility pack on
their machines to convert to whatever version of office they have. My boss
has now changed his mind and said that we should be ...