Formula Reproduction

[bodhisatvaofboogie]

Okay, here's my formula, very simple:

=D2/D51

Now that resulting value beigns in E2. When I try to drag the formula to do
the same things in every following cell in Column E, it doesn't work. I want
it to continue on down the line. BUT it not only changes D2 to D3, D4,
etc...it changes D51 to D52, D53, etc......how do I get it to not do that,
and yet reproduce on down the line correctly? Mind you I'm trying to get
this done in a macro as well, so if I can just record the process, I'll just
copy and paste the code into the macro. THANKS!!!

[Harald Staff]

Try

=D2/$D$51
A thumb rule: Put a $ in front of everything that should NOT change when you
fill down/right.

HTH. Best wishes Harald

"bodhisatvaofboogie" <bodhisatvaofboogie@discussions.microsoft.com> skrev i
melding news:8BBD12B0-04E6-4F2D-AEEE-10CF294B74DA@microsoft.com...
> Okay, here's my formula, very simple:
>
> =D2/D51
>
> Now that resulting value beigns in E2. When I try to drag the formula to
do
> the same things in every following cell in Column E, it doesn't work. I
want
> it to continue on down the line. BUT it not only changes D2 to D3, D4,
> etc...it changes D51 to D52, D53, etc......how do I get it to not do that,
> and yet reproduce on down the line correctly? Mind you I'm trying to get
> this done in a macro as well, so if I can just record the process, I'll
just
> copy and paste the code into the macro. THANKS!!!

[Dave Peterson]

Maybe you could just change the formula:

=d2/d$51

range("E2:E50").formula = "=d2/d$51"

Maybe????


bodhisatvaofboogie wrote:
>
> Okay, here's my formula, very simple:
>
> =D2/D51
>
> Now that resulting value beigns in E2. When I try to drag the formula to do
> the same things in every following cell in Column E, it doesn't work. I want
> it to continue on down the line. BUT it not only changes D2 to D3, D4,
> etc...it changes D51 to D52, D53, etc......how do I get it to not do that,
> and yet reproduce on down the line correctly? Mind you I'm trying to get
> this done in a macro as well, so if I can just record the process, I'll just
> copy and paste the code into the macro. THANKS!!!

--

Dave Peterson

[bodhisatvaofboogie]

Yeah, I figured that out shortly after I posted. *smacks forehead*
THANKS!!!

"Harald Staff" wrote:

> Try
>
> =D2/$D$51
> A thumb rule: Put a $ in front of everything that should NOT change when you
> fill down/right.
>
> HTH. Best wishes Harald
>
> "bodhisatvaofboogie" <bodhisatvaofboogie@discussions.microsoft.com> skrev i
> melding news:8BBD12B0-04E6-4F2D-AEEE-10CF294B74DA@microsoft.com...
> > Okay, here's my formula, very simple:
> >
> > =D2/D51
> >
> > Now that resulting value beigns in E2. When I try to drag the formula to
> do
> > the same things in every following cell in Column E, it doesn't work. I
> want
> > it to continue on down the line. BUT it not only changes D2 to D3, D4,
> > etc...it changes D51 to D52, D53, etc......how do I get it to not do that,
> > and yet reproduce on down the line correctly? Mind you I'm trying to get
> > this done in a macro as well, so if I can just record the process, I'll
> just
> > copy and paste the code into the macro. THANKS!!!
>
>
>