Re: Dragging by keeping the column the same

From: Ragdyer (RagDyer_at_cutoutmsn.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 01:14:29 -0700

Try this:

=INDIRECT("'Bloomberg-Model'!$G"&COLUMN(C1))

And drag across.

Don't worry about the row number (1) in the column function.
Doesn't really mean anything in this context.
Could use any row number you wish.

*BUT* ... I hope you're using this in the same workbook, on a different
***, because since this is using Indirect(), "'Bloomberg-Model' *must* be
open 

-- 
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"marksuza >" <<marksuza.1bl414@excelforum-nospam.com> wrote in message
news:marksuza.1bl414@excelforum-nospam.com...
> Hi guys.  No, what I want is for the column to stay the same but rows to
> change.  ='Bloomberg-Model'!$G3, if I drag this across, I get the same
> thing, the row number does not change.   ????
>
> Once again thanks.
>
> Marcos
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>