*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
>
>
ctv_Menginsert Baris Berisi Tanda Antar Data Kembar.xls
Description: MS-Excel spreadsheet

