Do that stuff in Excel with the macro recorder turned on. It will get you
started.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"apollo8359" wrote in message
...
I have been writting code in VB for Access, so I know the docmd. and me.
commands and a few others. Where does one find the commands for Excel. I
tried to write a little macro, (stepping was horrendous) and I was
clueless.
Specifically, I wanted to edit the cell, (F2), enter part of a formula,
hit
{home} to go to the begining of the cell, and enter the rest of the
formula,
then hit enter and move down one row. The formula part is the same for all
cells, so that would be in the code as well, I am not typing it in. I have
no
idea where to find the commands to create this macro. Any help would be
greatly appreciated.