If you want to do it in Access, I can help you.

Steve



"Michael Conroy" wrote in message
...
I am trying to speed up the repetitive tasks of editing a cell. My formula
is
simply pulling the value from another file, (copy and paste value won't
work
and is not dynamic). I need to copy this formula across eight columns but
the
original has absolute valued to the first column and row. Here is what I
want.

I want to have a macro that edits the cell, hits F4 three times, types a
close paren, jumps to the beginning of the cell, moves right one space,
types
Trim(, then hits enter. I know I can do this to the first cell myself and
then copy it across, but this activity happens often and I want to learn
the
commands. My Access skills don't translate and I want to learn a little VB
in
Excel. Thanks for your help
--
Michael Conroy
Stamford, CT