gagan_blue
New Member
- Joined
- Sep 30, 2014
- Messages
- 37
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
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