I need to write a document in Word which will use mail merge to insert
values from an excel file.
I need to be able to access any of 52 worksheets in a single workgroup,
specifically cells C33 and F4.

I have written my own function FindNominal (as below) in a macro in excel. I
want to use this function repeatedly in my excel spreadsheet.
Function FindNominal(NomCode)
FindNominal = Vlookup(NomCode, IMPORTDOC, 5 false)

Can I delete or re-set Header in Excel?  Header appears on pages 2 and 3 when
printed.  Header appears in body of printed  spread sheet.  Can I get rid of
this?

I've created a class module to capture a Shift+Click on a pivot chart,
which then opens the data associated with that point.  It works great
on pivot charts on their own sheet, but when I use the same code on an
embedded chart, it fails (error code -2147417848).

I experienced slowness in opening certain excel sheet, which is around
10MB in size. The excel sheet is created using Excel 2000. Have tried
upgrading to Excel 2003 with latest service packs but it doesn't help.
Suspect it is the recalculation that is taking up the processors. It is

I am working on a chart drilldown - I use drilldown to mean that a
Shift+Click opens the underlying data into a separate tab - and
although the event module I've coded works for 1 row by 1 column pivot
charts with any number of pages, I am having issues with drilling down

How to hide a Worksheet. Which means the tab might be visible below,
but the user is not allowed to view the contents.
Bart

I am trying to make a formula that gives me a count of how many row
have the same date and time...i have tried everything i can think o
and can't seem to get it...any help is appreciated!
i.e.

Thanks to all that have answered my last posts, and now for another please.
                         I have 3 columns    B, C, D.    I would like to be
able to select any blank cell in column B and turn only that cell yellow, and
of course the other columns  will have there own ...

I have a macro as follows:
Sub Macro2()
   ActiveCell.Offset(-1, 0).Range("A1").Select
   Selection.Hyperlinks.Delete

To clear everything to the right:
Range(Selection, Selection.End(xlToRight)).ClearContents
To clear the entire row:
Selection.EntireRow.ClearContents

Hello,                   
I have a table like below displayed. What I want is to count the no. of
"GIN'S" for any particular date say for the date of "14/05/2006" / for the
month of "05/2006". The answer would have been 6/10.                   

I created a button that clears the contents of a cell.
The command in Pivate Sub is:
Me.Range("B12", "B15").clearContents.
What is the command when I want:

I Have an emergency... I deleted a macro !!!
I have 60 rows with checkboxes on cells A1 trough A60 that
automatically as checked were inserting current dates on the cell next
to it.

Someone has given me a whole text document written in Excel 2002 and I wish to
use it in Word as a doc file.
I have copy pasted it but the cells come over too.
I can't unformat it so I can manipulate the text as I need to.