Windows XP Pro SP2
Excel 2002 SP3
I have a Userform that I like to change the size of as I progress through
various steps of a setup wizard that the Userform in question serves as the

Please help - I have the following on a spreadsheet:
col 36         col 37                   col 38                              
col 39       col 40
(No.)          (training title)        (description)                      

I've run into a small problem.  I have a XY chart that when activated,
runs some code that applies custom labels to each point.  It works fine
UNTIL I filter the data in the source sheet.  The chart shows the
correct number and location of the points but the labels are incorrect.

Just wondering how I can quantify dates? I have two ranges of dates,
and need to calculate the difference between the dates. (ie: Jan1,05 to
Jan1,06 = 365 days)
Thanks,

I have a wsheet with data from A1 to AJ1394 or so it seems.  Yet if i do
Ctrl + End the sheet scrolls to AJ31954.
There is no apparent data on row 31954 and running the little utility
recently posted to show the last real row and column produces the last cell

Can anyone explain how this is done or can it be done?

I'm trying to use excel to create some simple unix scripts.  When ever I set
up my data in excel I use copy and paste to put it into a text document.  
Doing this introduces unnecessary spaces that I end up manually removing.  
Any suggestions?

I have a method which returns Excel selection Range using get_Address()
method. I am tyring to return all the cells in that selection range.
Ex: If I have selection Range from $A$1:$B$2 (this is my input) then I want
to output

if I have a workbook object such as
dim wb as workbook
I know how to test if wb is nothing
but dumb question how do you test for Not nothing ???

I am trying to create an index of the sheets in my Excel file.  I'm using
David McRitchie's code to create the index and all is working as it should.
What I would like to do is skip the first two sheets in the workbook when
indexing.  How can I modify the below code to skip the ...

I am trying to disable and hide the "Print" option from "File Menu".Also  I
want to disable "CTRL + P"  and Print icon from standard tool bar.
I have written the code as follow but it's not  working.It's coming with an
error that" Invalid procedure call or argument."

Greetings,  Just recording a macro to insert a column in the middle of some
data, enter a formula and then copy the formula to cells below (having some
problems with blank rows screwing this up but I'll leave that for another
question).  The number of rows in this data will vary, ...

I am currently writing VBA code to refresh and update an Excel Workbook with
many queries and pivot tables - thus, it takes a few minutes.  
Does anyone know if a Message Box can be displayed telling the user that the
Macro is running, and then automatically diasappear after it ...

Have table of data
   2001      2002     2003
Name    #    Name    #    Name     #
A     23    A     33    A     29

 I am looking for a VB code which does the following:
I have a folder structure:
C:\Test
Under that folder I have some files :