Red_Dragon
New Member
- Joined
- Apr 22, 2002
- Messages
- 2
This is probably something easy for y'all, but I am beating my head against a wall here, just can't figure it out! Little help please? I am trying to modify a recorded Macro to move information from a "Summary" page to an individual history page. I am stuck at how to get the macro to drop down a row so as to ADD the new info in the same colums, one row down. Here is what I have worked out so far...
Range("C27").Select
ActiveCell.FormulaR1C1 = "=Summary!Venus_Refuse"
Range("D27").Select
ActiveCell.FormulaR1C1 = "=Summary!Venus_Regurge"
Range("B27").Select
ActiveCell.FormulaR1C1 = "=Summary!Venus_feed"
Range("B28").Select
Now what I want to do is have it drop down one row each time the macro is run.....so that the next time it is run it records the info across row 28, then drops the active cell to B29. Then the next time the macro is run it would record the info across row 30.....ect.
Any help please?
Range("C27").Select
ActiveCell.FormulaR1C1 = "=Summary!Venus_Refuse"
Range("D27").Select
ActiveCell.FormulaR1C1 = "=Summary!Venus_Regurge"
Range("B27").Select
ActiveCell.FormulaR1C1 = "=Summary!Venus_feed"
Range("B28").Select
Now what I want to do is have it drop down one row each time the macro is run.....so that the next time it is run it records the info across row 28, then drops the active cell to B29. Then the next time the macro is run it would record the info across row 30.....ect.
Any help please?