I have to create a number of pivot tables from the same block of data, and
repeat this with new data four weeks later etc. Data is always in the range
("A3:V" & x) where x varies each 4 weeks.
I have successfully in the past substituted "selection" for the R1C1 range

Is there anyway I can have Excel run code on a single click in a cell?
What I'm trying to do is I have a spreadsheet that has hyperlinks in
it.  However, I want it to run code when someone clicks on the
hyperlink before it sends the user on to the hyperlink.  I've found

I have done some searching of the archive but not successfully for the
following problem.
I have datafiles produced from an accounting ledger system and <null> cells
are produced for columns that have no data. The null cells are zero length

This goes with my question below but. I want to launch a "loop" macro when
the excel sheet is opened to monitor the time and then run another macro
when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
Also is there a better way to monitor the time than in a ...

I've looked for quite some time for a solution, but can't seem to find
it.
All I want to do is make a combo box in an User Form that works just
like the combo box in the Forms    toolbar.

Does anyone know how I could get a workbook/worksheet to automatical
email on a schedule?
Example: I want the workbook to be emailed on 9-30-2007, 10-31-2007
etc... every year do you know how this can be done?

I have a spreadsheet that I already have autofilter activated on, what
I would like to do is have a macro that I can pop on my toolbar that
will filter the file based on the active cell contents, I had a macro
that did this in previous verison of excel but I somehow lost it during

Has anyone experience with passing cell parameters to a file name using
a button and VB?  I have a spreadsheet I am using to send out to
multiple individuals to collect data and need a consistent format to
help manage the files that I will be receiving via email.

I need to create code to place text 2 lines below the total. The total line
is one space below the data.  I never know how many lines will be used as
this changes each month and for each file.
The text needs to go into clomun E.

I was wondering if there is a way to add Validation and Colouring to a
set of cells in a way that is faster than doing it cell by cell for a
whole region.
I have an arbitrary region of cells, each of which need their colour

i'm not sure if the client's settings are going to be set to auto update links
or not. in the workbook, under edit/links , i set the startup prompt to "don't
display the alert and update links". it still prompts. i tried workbook open
code:

I'm trying to send a sheet by email, but I want to send just a sheet. I'm
using this code:
ActiveWorkbook.SendMail Recipients:="sergio.aires@tecnovia.pt"
but with this code all file is send.

Any idea why I cant edit the name of the individual modules within VBA??
(Normal just a double click)
Regards
D

I have posted this in the general Excel discussion group but it might
be better here.
Hello,
Has anyone experience with passing cell parameters to a file name using

Is there a way to have a warning message pop-up before a macro is
applied (i.e., once you press the macro button, the warning will appear
and ask for a second confirmation of the process before it starts...)?
Thanks.