That's the issue, I don't want the contents of the cell to be in the macro,
just the key strokes. When I run the macro on cell A500, the formula
references a cell in another file, in Tab Austria at cell A8. I copy A500 to
G500, then that row gets copied down maybe thirty rows. Now in Cell A531, I
am pulling Cell A8 from tab Belgium in the same file as before. Now Cell A531
needs the absolute reference removed and the trim stuff added. Then it gets
copied over seven columns (G531) then down maybe 50 rows this time. So the
formula is irrelevant, editing it and adding trim or upper and removing the
absolute reference is my goal.

You have to understand that I am doing this to be able to get the data into
Access and this is the only way I can clean up a spreadsheet someone else
made, with over thirty countries in seperate tabs and different lengths of
information (rows). Once I trim, and upper these cell references, which needs
to be dynamic so that next month I can import them faster, I will import into
or link to this data from Access for a comparrison with other data. It's a
lot of steps. I hope this helps. I gave the keystrokes because I could do
this in Lotus 123 twenty years ago and I was hoping Excel could do the same
thing. No slight on Microsoft, I just thought that would be an easy way to
obtain my objective.
--
Michael Conroy
Stamford, CT


"Rick Rothstein (MVP - VB)" wrote:

A macro won't need to implement manual keystrokes so, instead of telling us
the keystroke sequences (what are the three F4s for?), show us a sample of
what is in the cell and what you want it to look like after editing.

Rick


"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