And? What makes it impossible to copy Ron's formula down and across?
The only difference is that your formula can be moved, but you want to copy,
right?


"veryeavy" wrote in message
...
I want to be able to copy this formula down and across.

"Ron Rosenfeld" wrote:

On Mon, 5 Jan 2009 17:19:01 -0800, veryeavy
wrote:

The reason I want this is have a formula that can be copied down and
across
that refers to the top cell in each column to which is copied.

Hopefully my header line makes it clear that playing around with "$"
signs
is not the answer.

It makes it clear that you don't WANT to "play around with dollar signs"
but
not clear why =A$1 wouldn't work.

--ron