Copy the formula from the formula bar, that way you are copying text instead
of a cell reference.

--
Regards,

Dave


"G" wrote:

Somewhat of a novice with Excel ... how do I copy a formula and paste it
without having the formula change the range?

Here's what I'm copying:

=VLOOKUP("1A",Players!C4:F57,4,FALSE)

I'm pasting it to another cell and here's what's being copied:

=VLOOKUP("1A",Players!C8:F61,4,FALSE)

I want ALL copied cells to have the range C4:F57. Thanks.

G