I have a spreadsheet where column A contains 4 character department codes
i.e. A123 and column B contains multiple 4 character department codes
separated by commas.  I want to find the value A123 in either column A or
column B and if found put a Yes in column C and if not found ...

We are trying to automate the creation of a column chart with two data
series, wherein one of the series is attached to the secondary axis.  We
create two additional 'dummy' or blank series with zero values (two series
attached to primary axis; two series attached to secondary ...

I have a macro that creates a text file (c:\temp.txt) with single entries per
line.  
example:  server1
              server2

Just went to update a spreadsheet. Selected Tools, Macro. None there.
Checked another spreadsheet and same story. Checked December updates
installed yesterday and no obvious candidates that I could see but most
updates nowadays for my system are security related.

I have a set of sequentially numbered files (starting at 1000.xls) in a main
folder that contains subfolders. I want to import data from certain fields,
with a new row for each file. I currently am using:
='P:\Folder 1\Main Folder\subfolder\[1002.xls]POForm1'!$L$1

I have an Excel macro that runs fine on many people's computers, but on one
person's machine the delete line (set off with asterisks below) takes
forever; when she gets to it, everything in the Task Manager related to
Microsoft Office (not just Excel) shows the ol' "Not ...

Is it possible and can one of you guru's help me with the creation of what I
am calling a double ended search. There are two parts to the search I am try
to accomplish. All this happens on a form when the user clicks the 'GO'
button.

Let's try this again.
I have the following code:
       Set mySourceRange = mySourceRange.CurrentRegion
where mySourceRange is already a defined range.   There is a region of data

I have VBA macro that converts excel to csv. It also removes hidden
characters. But if a cell start with "=" then it gives an error (I used clean
in the VBA). I know that = is for entering formulas. But I enter in the cell
as '= sfdsdfdsf. This way I can put = as the first letter ...

I have a string for example "NAM-1" in a cell in, say sheet 1. I want to
search this string in sheet 2. However sheet 2 does not have "NAM-1"; instead
it has "NAM". Is there a way to do something like Cells.Find("NAM-1") in
sheet 2 and do a partial match with "NAM".

Good morning.
I want the workbook user to be able to round values -- either up to a
selected interval, down, or to the nearest.  The only related VBA function
I'm able to find is rounding to a number of digits.  For example, I want to

I add the following code into a workbook_open sub
Worksheets("DataInputSheet").Protect userinterfaceonly:=True
the phrase 'userinterfaceonly' does not capitalise as expected, and the
macros do not work as expected.  Is my syntax wrong?

I need to analize one range and to set some cells values as result of that
analisys.
I have tried with an udf but I can't to set those values.
I know the udf prevents to format the cells but I thought I was able to set

Good morning to all!
I am trying to attach a macro I created to a form button in excel 2003.  I
click the button however the macro will not run.  I thought it might hav
ebeen the security level but I changed that.  If anyone can assist me it

Afternoon all,
Im trying to programmatically copy and paste from one workbook into another,
with two seperate bits of data pulled from seperate locations.
So i have an excel file with two tabs of data, i then want to copy and paste