Here is my problem. I have data in columns A:C however the number of rows
will differ each time.
I need a macro that will paste a preset formula eg. (=sum(A1:C1)) into cell
D1 and drag it down to the last cell which contains data in the previous

I know this is a big piece, but I don't know how to separate it into several
smaller problems... Sorry if it's too huge for one time :-(
I "inherited" a workbook with 25 different macros that, once they are ran
together, they easily take half an hour. As far as I can see, the ...

is it Possibel to get a Animation Picture in a Userform
Animation like a Printer Working or som thing like that

I need to insert a procedure call into the BeforeSave event handler of a file
that is the result of a programmic 'Save As'.
A procedure makes changes to a template, imports a module to the template,
then saves the template as another file.  At this point, the user make

Given a properly formatted date and code of  CurMonth = Month([A400]) how can
I move the cell with date(A400) and have code follow change?  I've tried many
things -- none work.
What am I missing?  

If I may Please request Help with a big challenge:
I have a drop down list of codes, the codes read 1/5's, 1/5 & 1, 1/5 &
2 and so on.  I want to set this up so that when you pick from the drop
down list a code it will fill in the cell next to it the value that the

I know the row and column of a cell I want to display.
In VBA how do I get Excel to show the cell so identified in the middle of
the screen.
I know it's simple, but searching the help system doesn't give me the answer!

I use a macro to change information in csv files before importing into a
l;ivestock program.
The csv files always contains the same columns of info but vary in the
number of rows of information.

this is just an example i am using to point out, i am trying to open command
prompt, and run something in it from vba.
Private Sub cmd1_Click()
Dim OldPath As String

i am converting data from Word to Excel (not of table data) while
transfering data all the Enter Button signs (square) is also transfered
how can i avoid that? can any one know how to identify Enter Sign ?

For each possible result in a matrix i need to create an articlenumber.
(with a certain structure)
It is however very difficult to explain what i want without sending an
example.

I work at this german firm now and they use the DVS Reporter as a
add-in in Excel. I have never used this before in the US. Do you kno
whether there is some kind of support forum for it?
Thanks,

I need a macro to copy down formulas. The expected macro should do the
following:
Ex: I select the cells with the formulas and call the macro
1- Asks (input) for the "final cells", I write ex J:14000;H1400

I have written a macro which is saved in my Personal XLs file. How can I
export this macro to another user by email.
keep it simple please
anthony

Where I work people have their PC's set up with different screen
resolutions. This means that when my spreadsheets open up zoomed to 100% half
the data is off to the side of the screen. I use a macro to zoom the sheets
so that they can see the data. However where there are a lot ...