in xl go to tools-macro-vb editor
that will open vba
if you do not see the project - vbaproject window
go to view-project explorer
in that window you will see all xl workbooks opend
click on the plus sgin next to the one your recoreded the
macro in
if it is a - then you can already see the object folders
click on the modules +
if it is a - you can already see all the modules
double click on all the modules untill you find the one
that contains the code you recoreded

ya i dont care about spelling or grammer :)

-----Original Message-----
LOL, I was recording a macro where I insert a line to
see the code, when I
decided to come see if I had an answer! ;-)
Thank you, I guess you're right, that will be the best
way.

Now, I've just finished recording it, but I can't find
where I can see the
code (My VB is open and it is not there as an object...
normal? I'm not sure
where to look)

Marie

"Kris" a écrit
dans le message de
...
Probably the best teacher is the macro recorder. Just
start recording a macro, do what you want to do, and
take
a look at the code. This is how I started learning VBA
Programming in Excel. :) And from what I have read
about
what you want to do, the macro recorder should be able
to
give you everthing that you need.

Then about the only thing that you have to worry about
is
how to incorporate variables into the statements since
obviously all of the statements in the auto generated
code are going to be hard coded values.

Anything you can do manually, you can find a way to do
it
in VBA.

Also, highlighting a command and pressing F1 will bring
up the help for that command, and although Microsoft's
help is lacking in some of its applications, it is
quite
good with VBA, complete with examples of most commands.

-----Original Message-----
Is there a site where I could find a list of the
functions so I can work
with Excel?

I never programmed with VB and Excel before, but I
usually find my way
out.(I programmed a bit in VB, but a long time ago and
in Basic, even before
that. I have a good basis in C)
I intend my "programme" to search through a table and
if
the first cell of
the row meets a condition, then insert a row after the
last one entered and
paste the information in the following cells of the
row
on that line in the
columns I want.
So.
1- can I look right into a table or must I copy the
info
into a variable
(which would be a table).
2- Can i programme all the actions I can do in Excel?
Like inserting a row.
3- can i indicate a cell where I want a variable to
print it's data.

Thank you

Marie


.



.