Hi , I have a question for you ..... I  need to have dynamic Validation Lists
and I have implemented a solution that I found in this forum , using the
option in excel Insert - Name - Define  I have defined my lists of values ,
but they are 85 posible lists , do you think that is ...

Currently Excel allows operands of various types to be used in formulas.  
Operands such as Number, Cell References, Names, Labels, and Functions are
among those currently allowed.  I am interested in whether or not it is
possible to build a user defined type, essentially a string ...

I am trying to put together a very simple piece of code that copies data from
one sheet and pastes into another
However every time a new worksheet is created the code cannot find the last
active sheet

Hi , I am using the next line :
ActiveWorkbook.Worksheets("A").Columns((ConvertToLetter(inicol)) & ":" &
msConvertToLetter(endcol)).Select
Does exist some way for using only the Column Number ?  I would prefer don´t

On previous versions if you put E&xit within the Caption property of a
command button, when you ran the code you could press Alt + X as a shortcut
to close the form. Does anyone know how to do this in Excel 2007 as this way
doesnt work.

How do you call an excel macro from Outlook? I have an excel macro
that relies on an email I get everyday, so I have a macro in Outlook
that copies the excel attachment to a certain folder. I would then
like that macro to open up a workbook in Excel that has my macro in

Does any on know how to use the offset function to select a range in another
excel file
I'm trying to use this with the sumif function, and want to select the
column location based on target location column A

I have a few macros i am writing for mulitple users to access in multiple
spreadsheets that may get updated on occation. Is there a way to store them
on a server and have everyone pointed to it? I dont really want to have to go
update everyones machine with a new personal.xls ...

This could be tricky to explain but I'll give a shot...
I have an absence tracker, the workbook contains a Summary sheet and 12
month sheets (January-December)
On the summary sheet..

hi,
is seem to be going round in circles with this one and wandrered if you can
help?
i have two columns of data say A and B and some of the cells in column a are

I learnt VBA a few years back and despite being a non-programmer, i
really really liked the way it works with Excel. VBA have been
constantly amazing me with its capabilities to perform various
seemingly tough tasks. From looking for all files in a folder to

If I want to have the same Word 97 macros (and custom menus and toolbars) on
my home machine as on my office machine, I bring home the Normal.dot file.
Is there an equivalent way of doing this in Excel 97?

Hi! I have a macro that sometimes opens another workbook. However sometimes
that workbook is already open. In that case I do not want to reopen it. I
have a UDF that checks if the workbook in fact is open but the problem is
that I get Error 9. Is there any way to check if the ...

I need VBA code to be able to merge cells which i could asign to a command
button

Hi everyone,
Somehow i need a formula or something similar which will do the following.
Basically, i have a column (A) of cells with different dates in them (e.g.
11/10/07). I then have another column (B) with some blank cells and some