Split function and "expecting array" error message

Hi all,
I'm getting an error that I'm not quite clear about. I'm essentially using a fuction that Mr. Leith Ross provided here: http://www.excelforum.com/excel-prog...xt-source.html to grab text from a web page.

I want to create 100 rows of data based on the array housing that data using the SPLIT function.

Please Login or Register  to view this content.

I'm hoping to take the first 100 lines of code (x) as delimted by a semicolon, and write them into the first 100 lines of column A.

However, I'm getting an error message "Compile Error. Expected Array" on the line Range("A" & y") = x(y) ... spefically on the "x"

What am I doing wrong? Arrays are fairly new to me, so be gentle

You have declared x as a String rather than as a Variant
(it [x] will become a Variant Array via the Split)