I've been trying to write some vb to autogenerate a scatter graph where the
data is list in one worksheet.  The data comprises dates and values bewtween
1 and 25.  The x-axis is the timeline and the y axis is 0-25.  There have to
be 4 series where for example 20-25 are coloured ...

I have a workbook with 12 sheets in them
it got 11 sheets for 11 employees say Fred Kathy mark so on...
every worksheet has row 30 to 33 to column A to U reserved for employee
comments

I have a sheet with data. Based on a selection i want to insert 3 blanco
rows on top of the already existing information. So normally I have row 1 to
xxx filled, and I now need 3 blanco rows to insert from row 1 to 3. Any code
for that?!

Getting a 1004 error - select method of range class failed - with the
following code:
Sub unhide()
Dim sh As Object

Hi,
Is there anyway you can get a vlook up to match two values to bring back a
number.
e.g.

This will probably be very simple for some of you, but it's got me
stumped.
I have a 3 sheet workbook, sheet three generates 10 random numbers
between 1 & 300. Sheet 2 has three pivot tables (different

How do I interrupt long running calulations?
I would like to catch the escape button and stop the calculation if
possible.
Lars

I have imported a whole bunch of data into Excel.  It is employee data
and each entry will have the employees name in Column A.  What I want
to do is make the cell contents of any duplicate entry blank so that I
end up with a whole bunch of entries for each employee with their name

Does anyone mknow how I would reference "Sheet2" to a cell in a worksheet
Need to be able to change the worksheet name based on a cell
Thanks
='C:\Documents and Settings\FP&A\Templates\[SMP2Data.xls]Sheet2'!$A$1

I'm trying to build a worksheet to store all of my DVD's on.  This will
include columns with Title, Wide/Full, Director, Actor, Actress, Release
Date, ... (the columns may grow as needed/desired)
1. I'm trying to write a macro that will find the bottom row that has data

I've a question that relates to VB and Microsoft Word, not Excel.
Can I ask the question here, or does anyone know if there's a similar
group like this for Word ?
Thanks - Kirk

Okay, not sure why this isn't working so need your help.
In cell AA2 I have the following formula: =TODAY()
In cell AB2 I have the following formula: =MONTH(AA2)
Cell AA2 returns today's date. Cell AB2 returns the month of the date in

Hello from Steved
Can I combine the below to work on the same worksheet ("Sheet1") Thankyou.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim TimeStr As String

I have a macro that sorts ascending when first clicked. Is there a way to
sort descending automatically if same button clicked a second time. I tried
to set a global variable to track what was used last time, but received an
error. The only way I can think of is to write to a ...

In cell A2, there is char 2328050010001023841.
The format for those value must be string instead of number based on Excel's
specifications,
which has 15 digit precision.