I'm trying to work with graphs and dates, in my code I'm using Datediff to
get the serial number for a given date and then graph the value. The problem
is that the difference between 04/01/2008 (mm/dd/yyyy) and 01/01/1900 is
giving the serial number of 2 days earlier. I know that ...

Help
Open this screen wide...
I know I can do this with aray. Can anyone help me??
My coulumns are 3-73

I am trying to read the array (m1:O1) in a Range command
using a for next loop where   'gm' is the incrementor
For gm =1 to 10
need to convert  .Range("M1:O1") to increment .Range(gm,13:gm,15)

I have two general questions.  Sorry if this is vague!
1.) I have a Workbook with several macros that I use to calculate pricing
for our products.  On the pricing sheet, I would like to access the database
so I can easily add customer information instead of cutting and pasting all ...

I cannot add parameters to external data connection (SQL query) in Excel
2007.
I am trying to add an external data connection in Excel 2007. I create a new
connection to my SQL Server. I change the properties to a SQL statement. I

Depending on the value of Range("a1"), a range address is stored in
Range ("b1") as follows: Master!$B$31:$B$52. How can I use the  value
in Range("b1") to set a range in vba code?
Any other suggestions also welcome.

I need an array to get the values from a list of labels.  How do I do this
using:
for i = 1 to 5
  a(i) = label(i)

Is it possible to change the name of pictures in a workbook? E.g. rename
Picture 52 (name given by Excel itself) to Log 01.
Regards

Below code removes word 'SADMIN' if found in each cell of column M of
sheet2.
----------------------------------------------------------------------
Sub RMV_SADMIN()

I've written a function that I am using over and over again in the
rest of my code. One of the arguments is one of several acceptable
strings and I don't want to have to keep typing it with opportunity
for error. Ignoring error control practices, my question is, how can I

just for curiosity,can it be posiible to add control with the help of a
control,
I have 2 option buttons ,By clicking Optionbutton1=add  text box1 to the
userform.

Can Anyone advise how to add a customised button to excel 2007 ribbon. i
want to attach a macro to this so that when pressed the macro runs
Many thanks in advance
Gibbtky2

Windows API (Application Programming Interface) is very useful, my question
is: I have a copy of the Text file that includes all the API functions and
constants, but how one earth do find out what each of them does and how do
combine different Functions to get my end result

I have an Excel 2002 autoexec workbook which starts automatically when
Excel launches, sets some defaults, then closes its own workbook
again.
It neither reads nor writes to the worksheet, or does anything else to

Hi I am new to VBA Programming. So excuse me if the question is a very basic
one.
I am  trying to write a macro for to calculate price and stock availability
for a product . Before I look for the product by typing the product number, I