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

Jack,

ActiveCell.Value = ActiveCell.Value


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


"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

Thanks that is just what I wanted

"Beto" wrote in message
...
Jack Schitt wrote:

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.

Instead of that you could use this:

Sub Text2Number()
ActiveCell.Value = ActiveCell.Value
End Sub

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.


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

Great, thanks

"Chip Pearson" wrote in message
...
Jack,

ActiveCell.Value = ActiveCell.Value


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


"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





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

Jack Schitt wrote:

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.

Instead of that you could use this:

Sub Text2Number()
ActiveCell.Value = ActiveCell.Value
End Sub

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

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