Loop, if found, increase range variable.

**NewGuy OnBlock** · 04-18-2015, 05:31 PM

The range is unknown until it loops through a specified range A1:F20. Once a value is found while looping, add that range to the range variable.

thanks for looking.

**davesexcel** · 04-18-2015, 05:38 PM

Select A1 from range("A1:F20")

Please Login or Register  to view this content.

Find the example here.
http://www.xlorate.com/excel-vba-loo...e%20to%20Range

Also a YouTube vid
https://www.youtube.com/watch?v=J3v8...ature=youtu.be

**NewGuy OnBlock** · 04-18-2015, 05:46 PM

Wow, Thanks a lot for the quick response, this is just what I was looking for.

Loop, if found, increase range variable.

LinkBack

Thread Tools

Rate This Thread

Display

Loop, if found, increase range variable.

Loop through range and add range to union range.

Re: Loop, if found, increase range variable.

Thread Information

Users Browsing this Thread

Similar Threads

creating a loop for saving a file and increase a variable by one after every saving

Increase copy and paste range after each loop

[SOLVED] For...Next loop - trying to have named range increase by count of 1

Why did an inner loop variable start overwriting the outer loop range suddenly?

How to exit a loop once the value is found in the range

Bookmarks

Bookmarks

Posting Permissions