Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Hey everybody, I want to create a code that does the same for all my 1300 firms in the sample. The problem is that some cells are supposed to stay the same, but that others are supposed to go down one row with every iteration.
FinalRow = Selection.End(xlDown).row
For x = 2 To FinalRow
ActiveCell.FormulaR1C1 = "=RC[-3]-'Final Sample'!r2c7+1"
Where it says "r2c7" I need it to be r3c7 in the next iteration and so on, so that the cell reference goes down one rown every time. I thought of something like an x (rxc7), but I did not know the syntax. If that's not possible with an x, I am open to suggestions... It should be really easy right? Thank you in advance.