Don't use SendKeys. Instead, select the cells in question and run
the following macro:

Sub AAA()
Dim Rng As Range
For Each Rng In Selection.Cells
Rng.Formula = "=" & Rng.Text
Next Rng
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Beancounter" wrote in
message
...
Yes, I need to create a formula from the existing cell contents
by simply
adding a = sign to the cell's current contents (over 12,000
cells in one
column). I, too, thought a macro would work, but don't know
how to program
it to repeat the keystroke series "F2, Home, =, Enter" in a
columnar range.
Many thanks for your assistance.
-Bean

"Gord Dibben" wrote:

Bean

Sounds like you are attempting to add an = sign to existing
cell contents.

For what purpose? To create a formula? What is the data
currently in the
cells?

Perhaps there is another way to do what you want.

I can think of a User Defined Function that evaluates cell
contents depending
upon what is currently entered in the cells.

Or a macro that will add the = sign to all cells if that's all
you want.


Gord Dibben Excel MVP

On Sat, 22 Jan 2005 13:09:03 -0800, "Beancounter"
wrote:

I want to program an Excel macro to set a columnar range,
then perform the
keystroke series "F2, Home, =, Enter" repeatedly until the
end of the range
is reached. How do I teach the macro to automatically repeat
the keystoke
series? I am using XP, and Excel 2002 10.4. Thanks for your
help!!!