add rows/columns +1 to a certain row

[pltom55]

Hi so I need to get the values from 0 to 1824 by 1 increment, but I don't want to drag the copy button that far, how would I do that preferably not using code, but if it is the only method so be it.
Thanks

PS. i am aware of coping the (A1+1) for the entire row/ column but that will go on till the document doesn't have anymore room.

 

[NeonRedSharpie]

You would do that by going to cell 1824, placing the number '1824' and then using the A1+1 method to fill down. Once the value is in cell A1824 (or whatever column), you can use shift+ctrl+down to select the range to paste your formula into.

 

[pltom55]

Worked like a charm
thanks