I have a spreadsheet of some 12000 rows - some data in the columns is static
- some will be entered by a user (who may also add additional columns) and
the rest of the data will be imported from a seperate spreadsheet.  I am not
allowed to use access.

How or what is the vba syntax if i want the user to select a atrget sheet for
a macro as an input?

I would like columns C & D to concatenate with a space and a comma seperating
the two words in each of my many sheets. the columns remain the same all the
time.
How do i do this? i tried using the concatenate formula in my macro code but

Can a macro automatically be executed by the changing of a cell value?
I have someone who is a master sheet of data.  He wants to split this sheet
based on won/lost value in a cell.  The data will be moved to a "Won" sheet
or "Lost" sheet based on that indication of won/lost cell ...

In sheets "Master" I have:
a)  cell A1 with name of sheet (Ex TEST1)
b) this formula =VLOOKUP(C2,Test1!E20:H24,2,FALSE).
If I change A1 in TEST2 I need to search Vlookup in it, so the formoula

My scrollwheel does not function as scroll in the VBA Code area, but
in the Project Explorer it works fine
Please Help
regards

Can you tell me why when I run this userform that it erases the values in the
range A1:A12?
The userform initialize procedure runs but it erases the values in the cells
A1:A12 and it doens't have the list in the comboBox but other than that it

Sorry,  am I supposed to create a variable for the Listbox1.rowsource line?  
I still get runtime error.  It can't load the listbox.  It is just column A,
for easy testing I just used the first few rows but I need all last names in
the listbox.

I know what the problem is but not how to solve it.  The problem is there is
a list on the
worksheet that gets edited by the users so it has to stay on sheet 1.  I
need to capture this range and fill the list box. I have the variable range

I'm writing a VBA script for Excel 2003 that takes information from multiple
sheets
and mangles the pertinent information into one sheet. All the sheets have
the same format, just

I have a massive file (over 200mb) with over a dozen seperate sheets
all containing at least 3 pivot tables each. They all come from the
same data source (a sheet with an external data query) and have
multiple page, column and row fields.

I am getting an error message when trying to have a macro create a
chart.  The following is my error message:
Run-Time Error '1004'
Unbale to set the xValue property of the Seris class

I have written a VBA application that initially open 3 workbooks - one of
them in a minimized state. The application then open several selected
workbooks . Each workbook is minimized, modified and closed before the next
workbook is opened.

I have a simple Excel database containing 12 columns and about 3000
records.
One of the columns represents a simple Price field in which the
numbers are formatted for 2 decimal places using the format

I have a macro to trigger conditional formatting events in my worksheet,
based on the cell text content in column D.
I also need an event that will update the formatting if the date in column G
is less than now, i.e. when it expires.