I need your help to get rid of the Outlook security message that shows
up everytime I use this procedure that shows the Address Book window so
that the user can select an email address that will be stored in a
textbox for later use.

To all,
I have a workbook with many sheets, and wish to delete all of them
apart from the following 3:
WELCOME, ImportedRawData, + ImportedDataEdit

Hi: Can any one please tell me how to i copy data from one file sheet
into another file sheet?
Thanks.

First to pre-empt confusion, there's a potential difference between terms
XValues and x-values in the following.
Typically series XValues are 1st or 2nd Category X-axis labels. However in
some types of charts the XValues are actual x-values, not labels.

I have a macro that merges multiple spreadsheets for input into a
forecast.  The dates in the initial spreadsheet are in the format
"DEC-12".  The forecast requires the dates in the format "12/12/2006".
I fixed that but the problem is this.  Right now there are dates on for

Hi: Can any one please tell me how to i hide the sheets?
Thanks,

I need to take 2 data reports, held in Excel, upload them to separate
tables in Access, execute a query to find the difference between the
two and output this reconciliation to the same Excel workbook, albeit a
different sheet. Most of this I have found straightforward, but it is

I created a unique range with this piece of code:
   Dim allkodok As Range, osszsor As Range
   darab = Columns("B:B").End(xlDown).Row
   Set osszsor = Range("B1:B" & darab)

I trying to fig out what the formula is doing/
FormulaR1C1 = "=SUMIF(TOEPIEXP!C[2],1,TOEPIEXP!C[40])"
TOEPIEXP!C i know that TOEPIEXP is the worksheet what is the C?
[2],1,TOEPIEXP!C[40])" What is the [2] ? The 1 is the criteria. TOEPIEXP is

Currently, I have this simple macro to find the next empty row to paste
input from a user.
Range("B65536").End(xlUp).Offset(1, -1).Select
ActiveSheet.Paste

I'm trying to programmatically add data labels to a chart that is also
created programmatically. I've used the following to go through the
SeriesCollection(iSeries) added elsewhere in the subroutine:
Dim ptsPoint As Points

I wrote a sub in VBA for Excel that accepts either 1) a selected range
directly from the active worksheet, or 2) from an created array (have used
both "as Double" and "as Variant") by another routine, which in turn
uses the same selected range.  In my sub, there is an "if" ...

I am using VBA to open an excel file (week 40).  Is there any way to
use VBA to open the last saved file (week 41, 42 etc)?  I want to use
the most recent file to populate my data tables.
Many thanks

On my autofiltered sheet I have thousands of rows. Calculation is
manual to  filter easily.
But then CF is not working as expected I think it is because of manual
calculation.

On workbook open I have a message box telling the user
what workbook they are in.
I have two questions: When they click "ok" on the message box
I want the user form to open.