Creating a Macro that double click a cell

[JackHiro]

Hi All!

I'm new here so please forgive any of the stupid things I might say

I'm trying to create a macro that goes thru all the cells in a row, double clicks them and goes on to the next cell (all the cells already have values in them).
When I record this then this is the code that is written:

ActiveCell.FormulaR1C1 = "6"
ActiveCell.Offset(1, 0).Range("A1").Select

This actually changes the value of the cell to "6" or what ever was in that cell.
I've tried using "application.doubleclick" but that didn't work at all and the same with "sendkeys F2"
The cell have a data validation on them that I can't for the life of me see but I know that if the cell has a number in it a little Green "flag" appears at the right hand top corner saying that "the number in this cell is formatted as text" I need to do this on all cells so that the green "flag" will appear.

I hope this is clear enough and not too "dumb".

Thanks in advance for helping me out with this!

Jack

 

[Andrew Poulsom]

Welcome to MrExcel.

Try selecting all your numbers, choosing Data|Text To Columns and clicking Finish.

 

[JackHiro]

Thank you so much for your quick reply Andrew!
I've tried this at home on a file that I've created and it seems to work I will test it out tomorrow at work on the files I'm having trouble with.
Again, Thank you so much!

 

[JackHiro]

I've tested it today on the files that I had to use it for at work and it worked perfectly

Thank you so much Andrew!