Dear B-Exceller,


Bagaimana cara menampilan range yang telah kita namai

Contoh



Sub Macro1()

Dim sampleRange As Range

Set sampleRange = ActiveSheet.Range(ActiveSheet.Cells(1, 1), 
ActiveSheet.Cells(1, 4))

sampleRange.Name = "Range1"

MsgBox sampleRange.Name

End Sub



Kenapa hasil sampleRange.Name = Sheet1!$A$1:$D$1

Kok bukan “Range1”

Saya ingin mendapatkan nama “Range1”

Mohon bantuannya



Wassalam

Heru Safrudin

Heru Safrudin

 <mailto:[email protected]> PT. BISI

Kirim email ke