Getting my loop statements to paste at next empty row

I am new to VBA and am trying to get my 2nd, 3rd, 4th loops to paste at the next empty row after the previous loop finishes.

Here is what I have so far:

Please Login or Register  to view this content.

I can get it work properly if I adjust this value "ii = ii + 1" for each loop, but I would like it to be dynamic.

Appreciate any help or insights.

Hi Katy and welcome to the forum.

Please note Rule 3 of our forum baout using code tags
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

In addition upload your workbook so that we can see the request in context. It may also be the case that your goal could be achieved without a loop.

Yes, the paperclip 'attach' icon is a continuing problem - no don't ask!

You'll need to click the Go Advanced button at the bottom right of the posting window then look underneath for the Manage Attachments option...

@Jerry/Ford if you happen to see this. Any chance the Tech Team could get around to addressing this nuisance factor?

That's one of the longest procedures I've ever seen, and it wasn't made easy to find by having the DIM statements way down the procedure.

It's good programming practice to put all Dim statements at the top of a procedure and usual and much better to break a big procedure down into small sections of code, and call a sub section when necessary (passing any variables with the calling statement).

I'm finding it hard therefore to understand what the macro is trying to do.

Would you describe in a narrative form what the macro is supposed to do, which sheet(s) it operates on and where results are supposed to end up.

Hi,

I question whether a loop is necessary. Loops are inherently slow since there's a time overhead each time VBA jumps back to the Excel App, does stuff and then returns.

The fastest and most efficient way I know of doing these sorts of things is to use Data Filter and copy the filtered data using the xlCellTypeVisible syntax and paste to the appropriate place.