If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

Setting an ActiveCell equal to another cell

As the title suggests, I am trying to set the ActiveCell equal to another cell in another sheet:

ActiveCell.FormulaR1C1 = "='coefficients line 1'!RC"

is what I have right now. This was the easy part of what I wish to do. Moving cells from one sheet to another with a similar cell is easy, but how do you do this in a Do While loop as the other cells change in my second sheet?

What I mean is info is going into the activecell A11 this time, but coming from F1 on my second sheet. After the loop goes again, it is going into A21 from K1, etc. I know how to change the location of the ActiveCell, but do not quite understand how to change what that cell equals when it is not from the same location ever time (not Sheet 1 A1 equals Sheet 2 A1 everytime, but Sheet 1 A11 equals Sheet 2 F1 and Sheet 1 A21 equals Sheet 2 K1 and Sheet 1 A31 equals Sheet 2 P1, etc.)

So basically what I am asking is does anybody know if there is a way to have my ActiveCell.FormulaR1C1 = to a changing location from another sheet?

Please let me know if this does not make any sense and I will try to help clarify more. Thanks a lot in advance!!!

Re: Setting an ActiveCell equal to another cell

MAS1683,

Need more .... info!!!!

You appear to specify two, and indicate that in the loop there will be more, "activecells" and differeing "cells" where data for those cells is to come from.

1. Use of the Activecell, for that fact active anything just slows things down.
2. You all ready appear to know that VBA / Macro will be needed.
3. What I need is
.....A sample workbook
.....A clearer explanation as to what the formulat should be based on which cell the formula is going into.

Basically, the code starts by pulling information from 'coefficients line 1'!A1 and puts the information into the new sheet called "Break Points" into cell A1. Everything works the way that it should the first time through the loop. It is once I try to pull information the next time that problems occur. The next time the information that is desired from the sheet 'coefficients line 1' starts in cell F1 and is as follows:

This should put the new information in starting at cell A11 in "Break Points"... Information is put into cell A11 in Break Points, but not the information that I want, it just takes cell A11 from "coefficients line 1" instead of F1 from that sheet.

So, to make a long story short... I am looking for a way to put the information from F1 in "coefficients line 1" and paste it into "break points" cell A11, IHR cell D5 and paste it into "Break Points" cell B13; Information from K1 in "coefficients line 1" and paste it into "Break Points" A21, IHR cell G5 and paste it into "Break Points" B23 and so on, all while progressing through my Do While loop.

Hopefully this helps clarify, but if not feel free to ask for my clarification.