Help on VBA, newbie here

[DroZ3]

Hi,

I have seen multiple posts on this subject but I am not able to adapt the code to my specific need, please help.

I need to do the famous F2 then ENTER combination for the following :

-VBA to be available in sheet "Report XML" only.
-Starting with cell "T2", I need to do the F2/ENTER combination, need to go downward until I hit 50 consecutive empty cells, in case there are small gaps (always less20-25 cells) in the column.
-Since the column potentially has lots of active cells in a column I would like to increase speed by disabling visual feedback.
-Focus to return to "T2" when finish.
-Sheet "Report XML" is password protected but column "T" will not be locked.

Please add explanation so I can adapt to other sheets with same type of issue.

Thanks for the help.

 

[steve the fish]

If you click the column and press data-text to columns then finish do the same thing?

 

[DroZ3]

Yes, but people how will use the sheet have no Excel skills, they are importing data from our new ERP system thru a macro button but the pasted data is in text format so formulas don't work, I want to add the conversion code to the importation macro so they don't make any mistakes.