Object Required...

[cocacrave]

Please Login or Register  to view this content.

It says object required.. What am I missing?

[shg]

You don't use the Set keyword in assigning a scalar varaible -- it's only used to assign objects. So

Please Login or Register  to view this content.

... and Let is optional, so

Please Login or Register  to view this content.

[Philb1]

You're trying to set a variable for holding numbers as a range. Try removing Set

aRank = Mid(Cells(6, 2).Value, 1, 1)

[cocacrave]

Ok thank you, it works now