Excel A Painfull String operation taking ages to complete - Please help
Hi Forum - Salutations to the excel masters, MVPs. Looking to seek your help with something giving me pain from a long time. Very often I need to append apostrophe (') character to a column containing 700,000+ rows. So i have written this simple macro to do the job. But the problem is it takes lot of time (2-5 minutes). Therefore I wanted to get your opinion if there is an efficient and faster way to do this. Maybe instead of cell by cell operation, is there a way to do a range operation - Range = "'" & Range & "'". Sub AddApostrophie() Dim cell As Range For Each cell In Selection cell.Value = "''" & cell.Text & "'" Next cell End Sub
This question generated 13 answers. To proceed to the answers, click here.