The following snippet will select the specified named range
Function Goto_A_Name(ByVal sName As String) As Boolean
'
On Error GoTo Err_Going
Application.GoTo Reference:=sName
Goto_A_Name = True
Exit Function
Err_Going:
End Function
Welcome to VBA Tips & Tricks. All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too Happy reading
The following snippet will select the specified named range
Function Goto_A_Name(ByVal sName As String) As Boolean
'
On Error GoTo Err_Going
Application.GoTo Reference:=sName
Goto_A_Name = True
Exit Function
Err_Going:
End Function
How about
ReplyDeleteRange("RngName").select
I like this better, since it doesn't snap the view of the user to to named range. Thanks!
ReplyDelete