Thought I had finished, but a user of my spreadsheet has accidently
removed a hyperlink from the Index of the project I've been working on.
To ensure this doesn't happen again I'm swapping cell based hyperlinks
for VBA Command Buttons.  These have been fine but the last few are

All,
hopefully a quick question about why I am not able to use the fill
handle to drag certain cells in my workbook. I am still able to copy
and paste etc. and can use the fill command from the edit menu. The

I can apply Conditional Formatting to a single cell, e.g. E13, but how
do I apply the same CF to a range of cells, e.g. B13:E15, i.e. the CF
of all cells in the range is dependent on the condition being met in a
single specified cell in the range?

I'm trying to put together a macro that looks to see if a particular
word exists within a range in an excel spreadsheet and continues with
specific instructions if it does.  I know an if / then statment can be
used to look within one particular cell, can it be used to look within

I have a user who is experiencing problems with pivot tables.  Once a
pivot table is created, they are unable to change the selected items to
update the pivot table.  They cannot uncheck the currently select
fields, or check new fields.  They expierenced it a few months ago,

I would like to be able to change the destination
when I do a Save As.
I have an external hard drive that I keep all my
documents on so when

I have labels in Word that I want to use in Excel. If I just copy and paste
it I get 1 column with everything in it. I want it in separate columns. Is
it possible to do it automatically or do I have to do it manually?

I have labels in Word that I want to use in Excel. If I just copy and paste
it I get 1 column with everything in it. I want it in separate columns. Is
it possible to do it automatically or do I have to do it manually?

I need to create a user form where they will be able to pick one of the
status (Pending, Complete, Incomplete, Beyond). These 4 status will be
displayed using option buttons.After the user chooses the status, i
need the selected status to be displayed on the cell. (K4)

I have a list of expenses, some of these expenses are electricity bills.
I have a column A 'Date', column B  "Description", next column C is 'Amount'
and next D column is 'Paid'.
There are several entries for electricity mixed in with other entries such

Is it permissible to post a worksheet here in this group to ask and
illustrate a question/problem?

I have a list of audio books in an excel 2003 spreadsheet.
One column should show the duration of the book in this format:
8 hrs 23 mins.
But what shows in the column is a 5 digit number, such as 54463 as an

Just need some help with a problem I am having.  Currently I have an
access 2000 application that I am writing a function for.  This
function basically takes data from the database, calculate what values
I need and then export that to an excel worksheet.  The thing is I can

Was wondering if any of you guys knew anything about my problem. What
it is, its that I was imported Addressed from our inhouse systems into
an Excel Spreadsheet some of the addresses on the spreadsheet have been
deleted out as they are no longer required. I have then went into

I have a question about adding data in selected cells.
Let's say that column "G" contains dollar values, and that column "J"
contains the text either "yes" or "no". I want to sum all the dollar
values where the adjacent cell is "yes" only.