Background
I have a vba rutine that imports a csv file to excel.
The source application where the data is taken from sometimes contain a
semicolon sign ";" with a text field. The semicolon will cause an offset

My application has produced several hundred charts.  They display very nicely
on my desktop monitor.  I have transferred the charts to a laptop to be used
in a training session and the display of those colors is quite different, and
causes the chart to be much less legible.  I do ...

I want to copy date from one worksheet into another with copy past special as
a "value" from two columns. However if the department is the same in cell B1
as A1 I want B1 to be blank. Is there any one of doing this?

I recently received 2 excellant VBA macros from this group. I want to
select one of these macros to run within an existing macro. How do I
merge or integrate a macro into existing code?
Help will be greatly appreciated.  Wm

I know nothing about VBA programming so this may be simple for most.
I am trying to create a macro that once I click on the autoshape it
will copy and paste the object in the cell which I have select or
have

I have a spreadsheet with 12 columns of numbers preceded by one column
with labels.  I want to use the same spreadsheet for each month of
data and just hide the blank columns.  Since it is February, I want to
hide the columns for March through December (D through M) since they

I'm using Excel 2002. In one of the excel sheets, I have dropdown
control (Combo box). I want to populate the dropdown with the data and
values i.e. the data is visible to the user and value is the actual
value associated with an item. The data is coming from  sql server

Using Excel 2000.  Excel opens by preloading 6 files. I only want the
one file that I saved to xlstart. Using Windows Explorer I find only
the correct file in that location. The other files may be stored in a
temp file. I can't find where these files are located, so I can't

I have create a macro and when I go to the next cell and try to run the
Macro, it puts data in the first cell, but then goes to me original line of
data - it does not populate the rest of the 2nd row.
When I look at the macro, it seems to reference a specific cell. I need some

VBA / Xl 2002
I use a userform to make the user input in a time registration form. The
format on the userform form side is .text. When saving this information to a
different sheet I try to convert the text to values by changing the suffix

Does anyone know how I can make a dropdown list in Excel return a value that
is not necessarily in the list?  
Example - the list would include city names and possibly the corresponding
code, but I would like it to return only the corresponding three digit "code".

I need to open a whole series of workbooks. What i would like to be able to
do is if the workbook has a Password  (as in File Save As (selecting the
Tools Option then Password to Open)), close the workbook immediatley.
How do I do this?

I have calendar objects populating two text boxes in my Excel vba
form, with a third box to show the difference of the first two (I
subtract box 1 from box 2).
I am getting a mismatch error, however, and I was wondering if a

I use Excel but never program in it.  However, I use VBA in Microsoft Access
a lot.
Can someone get me started and tell me the syntax to program a spreadsheet
to move the focus from one cell to another once something is entered into the

The following code is supposed to compare all the names in row 1 with a list
on another worksheet.  If the name is in the list it continues on, if the
name is not in the list it deletes the column, if the cell is empty (NULL)
then I want it to ignore it and go to the next cell.