LinkBack URL
About LinkBacks
I'm indexing Activecell to a range and selecting it with the indexed name.
Range ("rng").select is not working. Why?
Sub indexing() Dim rng As Range Set rng = ActiveCell ActiveCell.Offset(2, 1).Select Range("rng").Select End Sub
I'm indexing Activecell to a range and selecting it with the indexed name.
Range ("rng").select is not working. Why?
Sub indexing() Dim rng As Range Set rng = ActiveCell ActiveCell.Offset(2, 1).Select Range("rng").Select End Sub
Last edited by Sriramroxx; 12-30-2019 at 02:44 AM.
Because your code is trying to call on rng via a string variable rather than the range object you've set it as.
Should be:
Rather than:rng.Select
Beth.Range("rng").Select
Thanks. I already said that rng as range. So I dont need to specify it.
I didn't say you did need to specify it, I said your code was calling on it incorrectly. Purely a syntactical error.
Anyway, glad it's solved and thanks for the rep.
Beth.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks