*select A2:A25
Tekan Shift + Ctrl + I
*

Sub InsertRow()
   Dim r As Long, n As Long, ar()
   ReDim Preserve ar(1 To 1)
   ar(1) = Selection(1): n = 1

   For r = 2 To Selection.Rows.Count
      If Selection(r) = Selection(r - 1) Then
         n = n + 1
         ReDim Preserve ar(1 To n)
         ar(n) = Selection(r)
      Else
         n = n + 1
         ReDim Preserve ar(1 To n)
         ar(n) = "!"
         n = n + 1
         ReDim Preserve ar(1 To n)
         ar(n) = Selection(r)
      End If
   Next
   Selection.Resize(n, 1) = WorksheetFunction.Transpose(ar)
End Sub



On Sun, May 15, 2011 at 1:53 PM, Contract Mining Assistant, Asam-Asam <
[email protected]> wrote:

>
>
> Dear teman teman pecinta excel,
> saya ada pertanyaan dikit.
> bagaimana memisahkan data pada suatu range dengan simbol tertentu.
> seperti file terlampir
>
> Terima kasih
>
> Salam,
> Rasyid
>
>

Attachment: ctv_Menginsert Baris Berisi Tanda Antar Data Kembar.xls
Description: MS-Excel spreadsheet

Kirim email ke