To All,
 I have a named range that includes some blank cells that I am trying
to eliminate from a drop down list on another worksheet.  I have Googled
the internet and searched through several Excel newsgroups and think the

suppose i hav two sheets as follows...
SHEET 1
    ID     location    country
1    211

I have a folder with x number of workbooks, each workbook has one sheet and
each sheet has a unique name. What I want to do is to copy all the sheets
from all workbooks into a new workbook.. So if I have 10 workbooks I want to
run a macro and get a new workbook with 10 sheets ...

This code works in Excel 2003, but gives me a Type Mismatch error in Excel
2007.
Sub aaa()
   Dim submissionXValsRange

I have come across a strange problem while using the Autofilter in
Excel Macros.
I have to Filter my data based on two columns. In One column i need to
place the filter with Entries equallying #N/A. And in the second one

This may be hard to explain, but here it goes.
I need to fix up some data I have for some econometric analysis. I
have average years of schooling for every country in the world from
1960-2000, staggered every 5 years (i.e. 1960, 1965, 1970, etc. 9

the code below works sometimes, and other times it doesn't work. I dont know
why, can someone help me figure out why.
Private Sub txtItemFob_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Select Case KeyAscii

I would like to use a macro to read in text from a text file that is
not delimited and store the data in variables.  For example, from line
5 of the text file I want to read from column 7 to 17 and store that
value in a variable.  After reading in values from various places in

Jeanmi
One can make blink a cell, but is it possible to have a
character in a word in a cell that blinks (with Characters ?) ...
Thank you in advance,

i have written this code and i want to choose the values from the
range "C" from a list box to edit or delete them, but i have many
problems, first of all the code should be restarted in order to take
the new aded values each time to enter the list box, but i need it to

I would like to create a drop down list for 12 names and a drop down list for
12 months that are relevant to the 12 names so that I can view their monthly
figures etc.
i.e. pick dave from one drop down list and January from the other to view

Actually did not know where to post this message, as there is no separate
group for VBA.
How do I look for shared resources in my network? I've walked through the
search results and found a code that uses the scripting object technique to

When you merge cells MS Excel warns you and asks for your permissoin to
continue. I like to have a similar facility when running a macro. I would
like the box to ask me for a yes/no or a value?
Could someone help me with VBA codes for doing that please?

I am trying to link a picture to a cell in Excel 2003.
My goal is to use vlookup command to pull out the particular picture related
to what I choose.
I am not able to make the cell and the picture link together.

I'm working with a textbox on a userform. As the input in the textbox exeeds
200 a msgbox apperas which warns the user. However, it is only a warning as
every value is possible..
However, when I doi want to alter the value and therefor 'empty' the textbox