@Kekth, Then you can set an integer variable and initialise to 2 - The first cell you wanna start writing. Then followed by incrementing the count variable for writing down to next cell . That can be passed to cell property.
If I am not clear, refer these
- Datta Iteration in Excel - #4 by Poovarasan2
- Write variable text in Excel cells, one by one with COUNTER - #2 by vvaidya
- How to write variable value in next available cell in an excel column? - #2 by ClaytonM
Regards,
Dom 