loop to select used range in a row

**stephme55** · 02-17-2016, 06:32 PM

Hello. How can I loop down the rows and select each range with values in it?

**InvisibleMan** · 02-17-2016, 07:04 PM

Describe the data layout. Which columns do you need to check? Do you want to select every non-blank cell in the range? Then what?

**EduardoHiguchi** · 02-17-2016, 07:17 PM

First, select the range you want to test, and then run the following macro, it will select the cells that have a value in them:

Please Login or Register  to view this content.

**InvisibleMan** · 02-17-2016, 08:26 PM

Please Login or Register  to view this content.

**stephme55** · 02-22-2016, 02:19 PM

@EDUARDO. Could you explain what each part of your code is doing? I struggle with the array and ubound stuff. Thanks.

@ invisible. Could you do the same thing please?

**EduardoHiguchi** · 02-22-2016, 03:54 PM

Stephme55,
Please check out the comments i have just placed in my code

Please Login or Register  to view this content.

**InvisibleMan** · 02-22-2016, 05:00 PM

Please Login or Register  to view this content.

loop to select used range in a row

LinkBack

Thread Tools

Rate This Thread

Display

loop to select used range in a row

Re: loop to select used range in a row

Re: loop to select used range in a row

Re: loop to select used range in a row

Re: loop to select used range in a row

Re: loop to select used range in a row

Re: loop to select used range in a row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need VBA to find letter A in Column A:A, select range, popup MsgBox then loop

Need to loop to a ceretain value then select a range of cells

[SOLVED] Select method of Range class failed when used in a Worksheets loop

loop to select range

Select Range using variables-used a For Next Loop

Loop to select range of cells representing a month....

[SOLVED] Specifying Range.Select in a loop

Bookmarks

Bookmarks

Posting Permissions