I am trying to figure out a way to make sure that the users of a spreadsheet
always we lets say the first two colums(freeze panes works here fine) but
also lets say the 3 colums ("DD,DE,DF")... I am restricting the scroll area
but if the user scroll with these restrictions the ...

Windows XP Pro SP2
Excel 2002 SP3
Are the named ranges within a workbook accessible via the name alone, or do
you have to specify the sheet if the named range is on a sheet other than

The code below works for Integer cel.values, but not for broken values.
I think it has something to do with countrysettings, in Belgium we use
comma's to represent broken numbers.
In the debugger I see that VBA builds the formula like this:

In a macro, I need to select a range of cells that I want to refer to
with the R[1]C[1] style.
I know the following works for a range from a relative Cell to
an ABSOLUTE one: Range(ActiveCell, "G4").Select

Why does the code below not set OptionButton1.Value to True?
Private Sub UserForm_Initialize()
Dim rng
Set rng = Cells(ActiveCell.Row, 1)

XL 2000
Can anyone point me to a bit of VBA that checks a user's PC for the
existence of a DSN?
Cheers

I have a macro that selects all cells in one row for which cells in another
row are nonblanks. For example, suppose that in Sheet1, ranges C1:R1 and
U1:Z1 contain values, and the other cells in that row are blanks. The macro
selects the corresponding cells in row 15, namely C15 ...

all
I have a data like this.
ColA   ColB   ColC  ColD
Red     HG     VG    WH

Im trying to get a cell to display either 1, 0 or -1 depending on other
cells product here's what i'm using
=IF(E5=0,0,IF(OR(B$5-E5<0,B$5-E5>4),0,VLOOKUP(B$5-E5,{-1,1;-2,1;-3,1;1,-1;2,-1;3,-1},2)))
i can get itto display 0 or -1 or 0 and 1, my criteria is this if E5 >

Hi everyone, i need your help with this..
I have a spreadsheet with 80 columns, and i need to insert 2 blank columns
after each columns  the spreadsheet would be like this:
     A     B    C     D     E    F    G     H     I     J     K  

All-
I am looking for code that will save a file automatically when the user
closes the file.  This file has no macro and I would like to use this code on
multiple files.  What do you suggest?

Do you any printing procedure with all exception...?

I've inherited an access database and it automatically imports excel
spreadsheets and convert it to an access table.  I can't figure out how this
is done, is there VB code that accomplishes this?  I've tried to identify the
code but just can't seem to locate it.  The name of the ...

I am aware that Excel has some built in limitations 32,000 iterations etc.
Is there some code I can run over a workbook that will report on each of
these limitations (all internal limitations)?  Ie formulas, colours used,
formats and fonts used etc ?

Someone gave me some code to manage the storing of parameters in the
registry. I sent him an e-mail asking how to use the macros, but I got back
an out-of-office message saying he would be away until June 15th.
My problem is the functions have no documentation for the arguments. So ...