Problem with Sendkeys Macro

[timbo1957]

I am having trouble making this work could anyone help please?

Lr2 is H6827 and is variable. I just want to do an F2 and Enter on the cell.

Please Login or Register  to view this content.

[TMS]

Why? Why would you want to do that? What are you actually trying to achieve? Using SendKeys is a very bad idea and is not recommended.


Regards, TMS

[timbo1957]

The file is a download and some of the cells are formatted to text. So I have built a macro to make various changes and this is the last part - I have to put calculations in various cells on the worksheet.

SendKeys was recommended to me years ago as a way to write F2 Enter into a macro. I have hardly ever used it but the one time I come to use it it won't work.

I wasn't aware it was a bad idea and not recommended.

Can you suggest something else?

[TMS]

There are various ways. Text to Columns, Paste Special, macro: format as General and use .value = .value.

It should be possible to record and generalise any of the options.

Can you upload a sample workbook?

Regards, TMS

[Vikas_Gautam]

what type of data is you want to format..?
There is an another way ie. TEXT TO COLUMNS..

For example some time what a data is copied or pasted / Exported then gets converted into text
so we generally have to press F2 on the cell and press ENTER to make it normal..

there is an alternative as well
select the range you want to format..
Press text to columns button and press next ---> next ---> Finish..

It will automatically change the format..

Regards,

[TMS]

It's not recommended because it is unreliable and difficult to control. You can end up sending key presses at the wrong time or to the wrong application.