Sub AddNameForMe()
Dim sh As Worksheet
Dim fr As Integer, cc As Integer
Set sh = Sheets("âéìéåï1")
fr = Selection.Row() + Selection.Rows().Count - 1
cc = Selection.Column()
Set MyRng = sh.Cells(fr, cc)
ActiveWorkbook.Names.Add Name:="MyNewRange", RefersTo:=MyRng
End Sub
ActiveWorkbook.Names.Add Name:="MyNewRange", RefersTo:=Selection(Selection.Count).Address
Copyright©1996-2021,Tapuz Media Ltd. Forum software by XenForo® © 2010-2020 XenForo Ltd.