(This a repost to bubble the query back to the top.  Still seeking a
solution.)
I wrote a couple of functions with data links to a second workbook.
The data workbook is already open when I open the workbook with the

I'm new to macro programming.
I need a simple way to sum values in one column based on criteria in
another column eg number of items per country.
Im trying to program this with a array where each element points to a

Could someone advice on the VBA statement that allows me to delete all
worksheets within my workbook except for Sheet1 and Sheet2.
Example: Mij Workbook contains (for example) the following worksheets:
Sheet1, Sheet2,Sheet3,Sheet4, Sheet5

How can I change the address of a hyperlink without having to change the
hyperlinks individually.
I have a worksheet with a few 1000 hyperlinks of the format J:\......... and
want them all changed to M:\.........

Hi all, i am using Chip Pearsons code below to insert some code in a
worksheet. When i start the macro with F8 and then run through with F5
it works fine, however when i run the full code excel gives me a dialog
box and says "Sorry excel encountered a problem and has to close" and

I have two worksheets:  Report and Weekly Report.  On the report I have the
data listed by days. Some days are five day work weeks and some can be up to
seven day work weeks.
Simple example below

Hi, I'm a VBA noob.  At most I glean from the genius on this forum and copy
and paste your functions into my workbooks.  I took a modified version of
this code directly from this forum, but I don't know how to change it so that
the input box will only pop up if the cell is blank. ...

I am learning some basics of VBA and I am trying to write a Sudoku creator.
The problem I have is that I run the code three times and on the third time
it crashes. When I re-run the code, the numbers appear in the same places.
Why aren't the numbers appearing in different places ...

In another language I am familiar with if I wanted to express the text
"-----" I could say repeat("-",5).  Is there something similar in VBA?

HI TWIMC,
I'm try to get Excel to use a default workbook when I click on the 'New'
workbook button on the toolbar. Yes I have the Book.xls file in my
'C:\Documents and Settings\mccake\Application Data\Microsoft\Excel\XLSTART'

I have a workbook where on one sheet the user can use a set of buttons and
dialogues to add new column headers to a table and then fill in the correct
default values for each row in that column. The headers shown are stored in
an internal datastructure and to ease insertion of ...

Is it possible to freeze the top rows and the bottom row so that the headers
and the totals are always visible. In this case, I could simply scoll in
between.
I am using Excel 2003 SP3. Thank you in advance.

In an earlier post:
http://groups.google.co.in/group/microsoft.public.excel.programming/browse_threa
d/thread/880c4966ae9e72ad?hl=en
I had sought help in extracting words containing capital letters and/
or numbers from cells in Column C to corresponding cells in Column D.

  I have a VBA program which will be generating a lot of data, and I
want to be able to view the data on a chart.  The chart only holds
32000 samples, and my program is likely to generate 100,000 samples.
So, I start out with the source data range being fixed at R1C2 to

I am working with real time data and came across a problem where if
you the data is changing and you are trying to operate on the data,
you will get an automation problem. My solution, is to snapshot the
data, set it off to the side and then insert that data into a