Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Validate Textbox entry
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Dave Peterson, post: 5897501"] You could use something like: Option Explicit Sub testme() Dim testRng As Range Dim myStr As String myStr = "a1" 'myStr = "Not a Range!" Set testRng = Nothing On Error Resume Next Set testRng = ActiveSheet.Range(myStr) On Error GoTo 0 If testRng Is Nothing Then MsgBox "Nope" Else MsgBox "Yep" End If End Sub [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Validate Textbox entry
Top
