VBA Paste Loop Question

[jgonza6]

Hello, I am currently using the following code to pull in data from various websites.

Please Login or Register  to view this content.

I have all web address' on column A, and the code looks at each link then pulls the 20 rows of data I need from the websites.
ex.
[/URL]http://finviz.com/screener.ashx?v=152[/URL]
[/URL]http://finviz.com/screener.ashx?v=152&r=21[/URL]


The problem I have is that the code will paste into cell B1, then paste into cell B2 etc. Considering the data I am importing is 20 rows long, I need the code to paste to every 20 rows in column B.

I can't figure out how to do that.

Thanks to anyone that can help.

[Kramxel]

try

Please Login or Register  to view this content.

[Kramxel]

Edit: Double post please ignore this

[jgonza6]

Thank you so much Kramxel! That worked!

[Kramxel]

your welcome.