Jack,

Someone here in the groups told me a much easier way to convert a block of
Text into Numbers.

Copy a blank cell
Select the cells containing numbers
Edit, Paste Special
Paste = Values, Operation = Add
(effectively adds 0 to the range)

Rob


"Jack Schitt" wrote in message
...
Hi

Can someone please give me an elegant vba method of simulating F2 followed
by enter on a specified cell without using sendkeys?

The purpose is to convert a number stored as text back to a numerical
value.

Any alternatives?

Thanks

--
Return email address is not as DEEP as it appears