Macro which record F2 in a column

[Jabj]

Hi all,

Instead of enter F2 in a column with 500-1000 values it would be preferable to record a macro which can do this.

I got all my values in column M starting with the values in M9 and then depending on some criteria in column A down to M900.

Thanks for input !

[JBeaucaire]

This question is non-sensical, incomplete. Attach a workbook and explain more carefully what you're talking about.

[Jabj]

Ok, I've attach a file which illustrates my issue

As you can see in Column I I got some data from an external source and then in column M I need to press F2+ enter but since I got between 700-1000 values depending on my input it would be cool if I can write a code in VBA which can do this.

Thanks.

[JBeaucaire]

1) Highlight column I
2) Press CTRL-H to open the Replace wizard
3) Find What: =
Replace With: (leave blank)