Formula Reproduction

B

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!!!
 
H

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
 
D

Dave Peterson

Maybe you could just change the formula:

=d2/d$51

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

Maybe????
 
B

bodhisatvaofboogie

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top