Coba ini: '======
Private Sub BuatRange()
Names.Add "RangeNama", Range("D3:D" & Range("D3").End(xlDown).Row)
End Sub
'=====
From: [email protected] [mailto:[email protected]]
On Behalf Of [email protected]
Sent: Monday, January 28, 2013 9:38 AM
To: [email protected]
Subject: [belajar-excel] Buat Nama Range di range tertentu
Dear Be-Exceller,
Saya mau buat nama range dari cel D3:D7, saya sudah buat code VBA sbb. :
tapi tidak berhasil, file terlampir :
Tolong pencerahannya,
Terima kasih,
Wassalam,
Tio
<<image001.gif>>
