KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Let's say I have the following code: Sub TestRangeLoop() Dim rng As Range Set rng = Range("A1:A6") ''//Insert code to loop through rng here End Sub I want to be able to iterate through a collection of Range objects for each cell specified in rng . Conceptually, I'd like to do it like so: For Each rngCell As Range in rng ''//Do something with rngCell Next I know I could solve this by parsing rng.Address and building Range objects manually, but I'm hoping there is a more direct way that doesn't involve string parsing.
Tags (comma-separated)
Save Edits
Cancel