"Sam" wrote in message
link.net...
Last week some nice folks here gave me a few tips, and I was able to
get
the macro I had been working on to run properly. Thanks!

But today, I ran the same macro on a worksheet that was laid out
exactly
like the earlier one, and I got `Subscript Out Of Range.' error. I made no
chages to the code.

Here is the line the program stopped at:

FullName = Worksheets("Sheet1").Cells(I, 4).Value

Apparently the syntax has to be:

FullName = Worksheets(1).Cells(I, 4).Value

I have no clue why, but my program runs after I made that change.