Setting Loop to the smallest number needed

**Jiptastic** · 03-20-2013, 12:34 PM

Thus far, when I want to loop something I just set the loop to be greater than what I need it to be.

Please Login or Register  to view this content.

But then I have to wait while the macro checks alot of empty cells below where I have the data. I know I could use

Please Login or Register  to view this content.

But could I do something similar to this??

Please Login or Register  to view this content.

**alansidman** · 03-20-2013, 12:39 PM

Why not use a last row scenario. Something like this

Please Login or Register  to view this content.

In the above code, each of the columns will be filled with a formula from row 2 to the last row with data in column A. In your case, your i = i to lastrow

**Jiptastic** · 03-20-2013, 04:38 PM

Hey. It works. Thanks.

**Jiptastic** · 04-01-2013, 05:53 PM

How can I do this same thing with Columns? Can't seem to manage it.

**alansidman** · 04-02-2013, 10:44 AM

Try something like this:

Please Login or Register  to view this content.

This will get you the last column.

Setting Loop to the smallest number needed

LinkBack

Thread Tools

Rate This Thread

Display

Setting Loop to the smallest number needed

Re: Setting Loop to the smallest number needed

Re: Setting Loop to the smallest number needed

Re: Setting Loop to the smallest number needed

Re: Setting Loop to the smallest number needed

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions