F2 + Enter macro stucks to specific cell

[elevisse]

Hi All,
I have same datas in E column (E5:E10000). I want to apply F2+ Enter for them if this cells not empty. This macro should be stop first empty cell. I am using below macros for this but It goos to E1918 cell and it is stick (hang up). Could you please help me regarding this case. Thanks.

Please Login or Register  to view this content.

[elevisse]

Hi All,
I would like to share solution for you. it was solved by Norie, Thanks Norie.

1 Select a blank cell and copy it.

2 Select the cells with the 'dates'.

3 Goto Paste Special and pick Addition from the operation section.

4 Format the values as date.

Please Login or Register  to view this content.

[romperstomper]

From here: http://www.mrexcel.com/forum/excel-q...ific-cell.html