Thanks to all responders.

Despite the several ways I tried to solve this problem, for some strange reason (mostly error 1004), I could not get it to work. Mike's suggestion ultimately led me to this solution:
[vba] Set uRng = Range(rankSheet.Cells(lastRow + 7, 2), _
rankSheet.Cells(lastRow + lastRow + 4, col))

uRng.Formula = formRank [/vba]
This worked.

I discovered that I could get around many errors (although I would ultimately get the 1004) by always using the :
[vba]Range(rankSheet.Cells(lastRow + 7,2), rankSheet.Cells(lastRow + 7, 2))[/vba]
instead of:
[vba]Range(rankSheet.Cells(lastRow + 7, 2))[/vba]
Both of these "seem" equivalent to me, but I got errors when I used the former instead of the latter.

Thanks again for all the help.