LinkBack URL
About LinkBacks
Hello. Why doesn't this code work to select row ranges in a range? I want to select B6:N6 and so on down the identified range.
Sub bill() Dim rng As range, rambo As range Set rng = range("B17:N17") For Each rambo In rng range.Select Next End Sub
Hello. Why doesn't this code work to select row ranges in a range? I want to select B6:N6 and so on down the identified range.
Sub bill() Dim rng As range, rambo As range Set rng = range("B17:N17") For Each rambo In rng range.Select Next End Sub
rambo.Select
Each cell in a range
You remind me of ammartino44. Are you the alias?
Anyways, in response to your question the variable rambo would be what you would use to select the range within the loop. rambo.Select. If you want the entire row it would be rambo.entirerow.select
If you are happy with my response please click the * in the lower left of my post.
AB33's code will, as noted, select each cell individually iterating through the range.
If you want to select one row at a time, then use this
However, be aware that this code doesn't really do anything. It just moves the selection around.Sub bill() Dim rambo As range For Each rambo In range("B6:N17").Rows rambo.Select Next End Sub
Last edited by 6StringJazzer; 01-20-2016 at 03:13 PM. Reason: made a couple of corrections to the code
@ stynkynts. I am!! I'm famousThanks.
@Stringer. Your code is what I was looking. What makes it select by entire range row as opposed to cell or the entire row?
.Rows is the attribute of a range that returns a collection of Rows within that range. The For loop iterates through those rows, assigning each row to rambo.
If you highlight a method or attribute in the VBA code window then hit F1, it will bring up a Help page for that attribute. Try it with your code and Rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks